topic Loading in date fields with varying month case in QlikView https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051457#M352884 <HTML><HEAD></HEAD><BODY><P>I have the following date field which loads in dates where the month is in the format Jan, Feb, Mar etc ... </P><P>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 ? </P><P></P><P>date(sales_date,'M/D/YYYY') as SALES_DATE</P></BODY></HTML> Thu, 04 Feb 2016 15:20:45 GMT 2016-02-04T15:20:45Z Loading in date fields with varying month case https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051457#M352884 <HTML><HEAD></HEAD><BODY><P>I have the following date field which loads in dates where the month is in the format Jan, Feb, Mar etc ... </P><P>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 ? </P><P></P><P>date(sales_date,'M/D/YYYY') as SALES_DATE</P></BODY></HTML> Thu, 04 Feb 2016 15:20:45 GMT https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051457#M352884 2016-02-04T15:20:45Z Re: Loading in date fields with varying month case https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051458#M352885 <HTML><HEAD></HEAD><BODY><P>=Capitalize('JAN')</P><P>or</P><P>=Capitalize(YourMonthFieldName)</P></BODY></HTML> Thu, 04 Feb 2016 15:22:42 GMT https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051458#M352885 MK_QSL 2016-02-04T15:22:42Z Re: Loading in date fields with varying month case https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051459#M352886 <HTML><HEAD></HEAD><BODY><P>Maybe by using date#() instead of date()?</P></BODY></HTML> Thu, 04 Feb 2016 15:22:47 GMT https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051459#M352886 Peter_Cammaert 2016-02-04T15:22:47Z Re: Loading in date fields with varying month case https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051460#M352887 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 04 Feb 2016 15:28:58 GMT https://community.qlik.com/t5/QlikView/Loading-in-date-fields-with-varying-month-case/m-p/1051460#M352887 Peter_Cammaert 2016-02-04T15:28:58Z