Discussion board where members can get started with Qlik Sense.
For some reason, Qlik seems to be having a hard time identifying and interpreting my date fields.
The field I have named date/time is showing my dates as:
So when loading the file, I have included these rows of script in my data load editor...
DATE#("date/time",'MMM DD, YYYY hh:mm:ss tt') as Date,
Am I doing something wrong?
Is there something I should be putting for those last three characters that are for the time zone?
Go to Solution.
Date(DATE#(left("date/time",len("date/time")-4),'MMM DD, YYYY hh:mm:ss tt')) as Date
Also try to covert this dates into Date format.
DATE( DATE#("date/time",'MMM DD, YYYY hh:mm:ss tt') ,'MMM DD, YYYY hh:mm:ss tt' ) as Date,
Thanks so much for your help with this script. This was my first request for assistance and I'm impressed.
Again, much appreciated.