month number to a month name

[rmanh]

Hi, Im not having much luck creating this function work, I have 2 fields, one displays a drop down list of months by number 01..02 etc. I would like to create a (if function?) to change the number to the month name in the other field (month name). Anyone do this before? thanks much

[comment]

Try:

MonthName ( Date ( YourMonthNumber ; 1 ; 1 ) )

Result type needs to be Text.

[mr_vodka]

Just to add to this, if this is strictly for display purposes, you do not really need an additional field to achieve this.

You can simply place another copy of the same field on there, select it, and then go to Date format (Format menu -->Date). Use a custom date format for the month name only.