https://community.qlik.com/t5/QlikView/date-formats/m-p/1522180#M437609 Why are you using five Y's instead of the usual four in your date format string? Tue, 18 Dec 2018 13:36:49 GMT Gysbert_Wassenaar 2018-12-18T13:36:49Z https://community.qlik.com/t5/QlikView/date-formats/m-p/1522177#M437608 <P>hi all&nbsp;</P><P>based on same field i am creating to date fields one is ok and the other add a '0' prefix..&nbsp;</P><P>date(datefield ,'YYYYYMMDD hh:mm:ss')</P><P>retrieves :</P><P>1.&nbsp;020181026 14:41:28</P><P>2.&nbsp;20181030 17:22:03</P><P>any ideas ?</P> Sat, 16 Nov 2024 04:56:23 GMT https://community.qlik.com/t5/QlikView/date-formats/m-p/1522177#M437608 ilanbaruch 2024-11-16T04:56:23Z https://community.qlik.com/t5/QlikView/date-formats/m-p/1522180#M437609 Why are you using five Y's instead of the usual four in your date format string? Tue, 18 Dec 2018 13:36:49 GMT https://community.qlik.com/t5/QlikView/date-formats/m-p/1522180#M437609 Gysbert_Wassenaar 2018-12-18T13:36:49Z https://community.qlik.com/t5/QlikView/date-formats/m-p/1522191#M437610 <P>Something like this?</P><P><FONT size="3">=<FONT color="#0000ff">date</FONT>(<FONT color="#0000ff">date#</FONT>('020181026 14:41:28' ,'YYYYYMMDD hh:mm:ss'), 'YYYYMMDD hh:mm:ss') </FONT></P> Tue, 18 Dec 2018 13:51:12 GMT https://community.qlik.com/t5/QlikView/date-formats/m-p/1522191#M437610 haupenthals 2018-12-18T13:51:12Z https://community.qlik.com/t5/QlikView/date-formats/m-p/1523702#M438219 Thank you for your enlightenment! Mon, 24 Dec 2018 08:35:29 GMT https://community.qlik.com/t5/QlikView/date-formats/m-p/1523702#M438219 ilanbaruch 2018-12-24T08:35:29Z