Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've a a string in my database as Start Date : 01/01/2011 12:21:34 and End Date as 01/07/2011 18:31:45.
I would like load as a date/time format in qlik sense when I load data in the script so it is easy to subtract two dates.
I want Qlik Sense script to recognize and convert to date/time when loading the data .
How can I achieve this?
Thanks
Hi Prashant,
If your date format is in string, try like below
Load *, Date(Timestamp#(StartDate,'DD/MM/YYYY HH:mm:ss')) as StartDate,
Time(Timestamp#(StartDate,'DD/MM/YYYY HH:mm:ss')) as StartTime
from urtable;
Same for End Date.