Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Transforming a Date

Hello -

I have a field called [Line item start date] which is in the format MM/DD/YYYY

I have created an inline table:

MonthMap:
Mapping LOAD * INLINE
[ mntNA, mntNM 
Jan, 01 
Feb, 02 
Mar, 03 
Apr, 04 
May, 05 
Jun, 06 
Jul, 07 
Aug, 08 
Sep, 09 
Oct, 10 
Nov, 11 
Dec, 12 ]
;

How can I apply this map to my date field so that the numerical months appear alphabetically. My end game is to create a list box of months and years.

Thank you.

0 Replies