2 Replies Latest reply on Nov 19, 2009 7:15 AM by Invectus

    Display Month as Text



      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