Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.