https://community.qlik.com/t5/QlikView/date-format/m-p/1640269#M447131 <P><SPAN>I have excel sheets where the data field arrives in two different formats, I would like both to format them in a single format, I'm trying this:</SPAN><BR /><SPAN>&nbsp;&nbsp;</SPAN> <SPAN>Date (Date # (field, 'gg-mmm-yy' OR 'DD / MM / YYYY'), 'DD / MM / YYYY') as Data,</SPAN><BR /><BR /><BR /><SPAN>but it doesn't work for a format type: 12-Jan-19,</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN>have you suggestions?</SPAN></P><P><SPAN>thx,</SPAN></P><P><SPAN>Billy</SPAN></P> Sat, 16 Nov 2024 19:48:03 GMT Billy_u 2024-11-16T19:48:03Z https://community.qlik.com/t5/QlikView/date-format/m-p/1640269#M447131 <P><SPAN>I have excel sheets where the data field arrives in two different formats, I would like both to format them in a single format, I'm trying this:</SPAN><BR /><SPAN>&nbsp;&nbsp;</SPAN> <SPAN>Date (Date # (field, 'gg-mmm-yy' OR 'DD / MM / YYYY'), 'DD / MM / YYYY') as Data,</SPAN><BR /><BR /><BR /><SPAN>but it doesn't work for a format type: 12-Jan-19,</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN>have you suggestions?</SPAN></P><P><SPAN>thx,</SPAN></P><P><SPAN>Billy</SPAN></P> Sat, 16 Nov 2024 19:48:03 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/1640269#M447131 Billy_u 2024-11-16T19:48:03Z https://community.qlik.com/t5/QlikView/date-format/m-p/1640275#M447132 <P>try like this:</P><P>&nbsp;</P><LI-CODE lang="markup">Date(Alt( Date#(field,'DD/MM/YYYY'), Date#(field,'DD-MM-YY') ),'DD/MM/YYYY') as MixDate</LI-CODE><P>&nbsp;</P> Mon, 28 Oct 2019 09:58:41 GMT https://community.qlik.com/t5/QlikView/date-format/m-p/1640275#M447132 Frank_Hartmann 2019-10-28T09:58:41Z