Transforming a Date

evansabres — Fri, 10 Apr 2015 14:25:06 GMT

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.

topic Transforming a Date in QlikView

Transforming a Date