AnsweredAssumed Answered

Display Month as Text

Question asked by Invectus on Nov 19, 2009
Latest reply on Nov 19, 2009 by Invectus


Display Month as Text


Hi guys,


I have a calculation designed to only display the Month and the Year of a payment and I'm trying to display the month portion of the date field as Text, i.e.: 11/18/2009 would be written "November"


Here's how I go about it:


GetAsText( Month ( Date_payment ) )  &"-"& Year ( Date_payment )


This returns: 11-2009


How do I convert the "11"  to "November"?


The calculation result is set to "Text"  and the storage options are set to "Recalculate when need".


I'm using FM10