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

    Display Month as Text

    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