Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to convert a field I have in Qlik Sense from the following:
DD-MMM-YYYY hh:mm:ss (e.g. it might look like 13-JUN-2015 12:21:33)
I want it to give me just the date without the time.
I've tried using the timestamp function both in the data load editor, and also whilst trying to create a master dimension, but it hasn't worked for me so far.
Can anyone please help?
Thank you
Try this:
Date(Floor(Date#(YourDateField, 'DD-MMM-YYYY hh:mm:ss'))) as Date
That looks like it has worked. Thank you!
Generally Qlikview automatically converts dates or time stamps into number. use the Floor function to truncate the time stamp.
Date(Floor( TimeStampField ))
This post give a good overview of dates & time fields. Get the Dates Right