AnsweredAssumed Answered

Display Month as Text

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

Title

Display Month as Text

Post

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 

 

 

Thanks 

Outcomes