topic converting data type from string to data and time in Qlik Compose

converting data type from string to data and time

eyadelnagdy — Fri, 14 Mar 2025 20:49:07 GMT

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

Re: converting data type from string to data and time

henrikalmen — Tue, 19 Mar 2024 11:42:47 GMT

Use the date#() function.

Re: converting data type from string to data and time

eyadelnagdy — Tue, 19 Mar 2024 12:26:52 GMT

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

Re: converting data type from string to data and time

henrikalmen — Tue, 19 Mar 2024 12:52:55 GMT

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.

Re: converting data type from string to data and time

BrunPierre — Tue, 19 Mar 2024 13:37:43 GMT

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

Re: converting data type from string to data and time

eyadelnagdy — Tue, 19 Mar 2024 15:53:44 GMT

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