https://community.qlik.com/t5/QlikView/convert-timestamp-string-from-csv-to-date-field/m-p/1609338#M445001 <P>Hi all,</P><P>I would like to convert the field TreatyPeriodStartDate from my csv into a date field, but this is not working.</P><P>could you please help?</P><P>&nbsp;</P><P>Thanks &amp; Regards,</P><P>Markus</P> Mon, 05 Aug 2019 11:56:47 GMT markus19-85 2019-08-05T11:56:47Z https://community.qlik.com/t5/QlikView/convert-timestamp-string-from-csv-to-date-field/m-p/1609338#M445001 <P>Hi all,</P><P>I would like to convert the field TreatyPeriodStartDate from my csv into a date field, but this is not working.</P><P>could you please help?</P><P>&nbsp;</P><P>Thanks &amp; Regards,</P><P>Markus</P> Mon, 05 Aug 2019 11:56:47 GMT https://community.qlik.com/t5/QlikView/convert-timestamp-string-from-csv-to-date-field/m-p/1609338#M445001 markus19-85 2019-08-05T11:56:47Z https://community.qlik.com/t5/QlikView/convert-timestamp-string-from-csv-to-date-field/m-p/1609373#M445004 <P>Date(left(TreatyPeriodStartDate,10),'YYYY-MM-DD') as Date_field</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 05 Aug 2019 12:33:02 GMT https://community.qlik.com/t5/QlikView/convert-timestamp-string-from-csv-to-date-field/m-p/1609373#M445004 Claudiu_Anghelescu 2019-08-05T12:33:02Z https://community.qlik.com/t5/QlikView/convert-timestamp-string-from-csv-to-date-field/m-p/1609375#M445005 <P>You can use Date# to interpret the date and Date to format it.</P><P>&nbsp;</P><P>Date(Date#(TreatyPeriodStartDate,'DD.MM.YYYY hh:mm'),'DD/MM/YYYY') as Date,</P> Mon, 05 Aug 2019 13:02:41 GMT https://community.qlik.com/t5/QlikView/convert-timestamp-string-from-csv-to-date-field/m-p/1609375#M445005 MarkWillems 2019-08-05T13:02:41Z