Two options.
One:
Add a lookup table like:
and join it to your month field.![]()
1 January 2 February 3 March . . .
Two:
Rebuild your date, then take the Month text:
Cheers,![]()
MonthText: Format(DateSerial(IIf([numYear]>30,[numYear]+1900,[numYear]+2000),[NumMonth],[numDay]),"mmmm")
Bookmarks