topic Re: Date format.. in QlikView https://community.qlik.com/t5/QlikView/Date-format/m-p/567114#M683778 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P>date(date#(fieldname,'DD/MM/YYYY'),'DD-MM-YYYY')</P></BODY></HTML> Tue, 11 Feb 2014 07:35:40 GMT 2014-02-11T07:35:40Z Date format.. https://community.qlik.com/t5/QlikView/Date-format/m-p/567112#M683776 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm using excel file as data source with date as one of the column. This date fields had mixed format type for example 14/2/2014 (date format) and 15-2-2014(General format). Is there a way to convert all the dates to one format at Qlikview level ?</P><P></P><P>Thanks in Advance</P><P></P><P></P><P>Thanks</P><P>Vardhan</P></BODY></HTML> Tue, 11 Feb 2014 07:26:19 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/567112#M683776 2014-02-11T07:26:19Z Re: Date format.. https://community.qlik.com/t5/QlikView/Date-format/m-p/567113#M683777 <HTML><HEAD></HEAD><BODY><P>Hi Vardhan,</P><P></P><P>Use this in load script</P><P>Date(Date#(PurgeChar(DateField,'/-.'),'DDMMYYYY'),'DD-MM-YYYY') as NewDate</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Tue, 11 Feb 2014 07:35:29 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/567113#M683777 Sokkorn 2014-02-11T07:35:29Z Re: Date format.. https://community.qlik.com/t5/QlikView/Date-format/m-p/567114#M683778 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P>date(date#(fieldname,'DD/MM/YYYY'),'DD-MM-YYYY')</P></BODY></HTML> Tue, 11 Feb 2014 07:35:40 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/567114#M683778 2014-02-11T07:35:40Z