Attached is the format of the data in Excel:
I need to Extract Date and Time as separate fields.
I used this:
Timestamp("Changed Time Stamp",'D/MM/YYYY hh:mm:ss TT')
But am still not able to pull out date separately.
What can I use to get Date as its own and Time as its own?
May be this:
Date(Floor([Changed Time Stamp])) as Date,
Time(Frac([Changed Time Stamp])) as Time
View solution in original post
For more information, have a look at
QlikView Date fields
(applies also to timestamps)
Why don’t my dates work?
Get the Dates Right
I have executed