Display Month as Text
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