converting data type from string to data and time

[eyadelnagdy]

Hello everyone,

in qlik sense

I have a timestamp in a string format and I need to convert it into a date and time with e specific format.

the idea is to be able to create a calendar or extracts month.week...etc from that field, which is not possible when it's a string

[henrikalmen]

Use the date#() function.

[eyadelnagdy]

when I use date#(fieldname) it generated another column which is actually the same

if I try to do Month(date#(filename)) it doesn't extract the month which means it doesn't understand it as a date

[henrikalmen]

No, you need to specify the format. If your date in a field MyDateField
is a text value like '09/12/24 13:00' then you do date#(MyDateField,
'DD/MM/YY hh:mm').

Please read the manual for the date#() function that I linked to.

[BrunPierre]

Date(Floor(Date#(Field,'YYYY-MM-DD hh:mm:ss.fffffff +ff:ff')),'DateFormat')

[eyadelnagdy]

I found an easier solution. I used left(fieldname, 19) to extract the first 19 characters which includes the seconds and qlik recognised automatically the date and time