Solved: convert timestamp string from csv to date field - Qlik Community

markus19-85 · ‎2019-08-05

Hi all,

I would like to convert the field TreatyPeriodStartDate from my csv into a date field, but this is not working.

could you please help?

Thanks & Regards,

Markus

MarkWillems · ‎2019-08-05

You can use Date# to interpret the date and Date to format it.

Date(Date#(TreatyPeriodStartDate,'DD.MM.YYYY hh:mm'),'DD/MM/YYYY') as Date,

Hey, Please don't forget to add kudos, like or mark as a solution if my reply has helped you at all! 🙂

Claudiu_Anghelescu · ‎2019-08-05

Date(left(TreatyPeriodStartDate,10),'YYYY-MM-DD') as Date_field

To help community find solutions, please don't forget to mark as correct.

MarkWillems · ‎2019-08-05

You can use Date# to interpret the date and Date to format it.

Date(Date#(TreatyPeriodStartDate,'DD.MM.YYYY hh:mm'),'DD/MM/YYYY') as Date,

Hey, Please don't forget to add kudos, like or mark as a solution if my reply has helped you at all! 🙂