Loading in date fields with varying month case

[#1]

I have the following date field which loads in dates where the month is in the format Jan, Feb, Mar etc ...

However in some cases the data contains dates where the month is in format JAN, FEB, MAR hence will not get loaded. How can I adapt my script to pick up months in both formats ?

date(sales_date,'M/D/YYYY') as SALES_DATE

[MK_QSL]

=Capitalize('JAN')

or

=Capitalize(YourMonthFieldName)

[Peter_Cammaert]

Maybe by using date#() instead of date()?

[Peter_Cammaert]

Note that for identical dates, only the first capitalisation of your month will be kept. All the others will be converted to the first one, because a QlikView symbol table will keep only one string representation for every distinct numerical value.