topic Date Format in QlikView https://community.qlik.com/t5/QlikView/Date-Format/m-p/245992#M93748 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>how to change the date format from: 'Jan11', 'Feb11', 'Dec11' etc. to '01.Jan11', '02.Feb11, '12.Dec11'. Please let me know if there is any specific function for this operation. Thanks in Advance.</P><P></P><P>Suresh </P></BODY></HTML> Mon, 02 Jan 2012 18:22:54 GMT 2012-01-02T18:22:54Z Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/245992#M93748 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>how to change the date format from: 'Jan11', 'Feb11', 'Dec11' etc. to '01.Jan11', '02.Feb11, '12.Dec11'. Please let me know if there is any specific function for this operation. Thanks in Advance.</P><P></P><P>Suresh </P></BODY></HTML> Mon, 02 Jan 2012 18:22:54 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/245992#M93748 2012-01-02T18:22:54Z Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/245993#M93749 <HTML><HEAD></HEAD><BODY><P>You can globally set the DateFormat with the variable in the script header.</P><P></P><P>Or using Date() function with an appropriate format code, maybe like</P><P></P><P>Set DateFormat ='DD.MMMYY';</P><P></P><P>or </P><P></P><P>LOAD </P><P>..</P><P>Date(DateField,'DD.MMMYY') as YourNewDateFormat,</P><P>..</P><P>From TableWithDateField;</P><P></P><P>DateField must have a recognized date type before your could re-format it with Date() function. If it's just a string, you need first to apply Date#() function. But, since your strings don't contain a Day, I don't know how you want to parse it in, do you keep a Day field separately?</P></BODY></HTML> Mon, 02 Jan 2012 19:34:28 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/245993#M93749 swuehl 2012-01-02T19:34:28Z