Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time stamp

Morning All,

I have a bit of an unusual time stamp that just wont cooperate. The date looks like this "2014/the following in my scriot05/21 12:09:22 PM" and I am trying to use the following in my script: " Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT'),'YYYY/MM/DD') as ADate" but is just not converting to a date, can anyone throw in some suggestions?

Thank you

H

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

Date(Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT')),'YYYY/MM/DD') as ADate

View solution in original post

4 Replies
tresesco
MVP
MVP

Try like:

Date(Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT')),'YYYY/MM/DD') as ADate

PrashantSangle

Hi,

can you post some sample date.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MarcoWedel

"2014/the following in my scriot05/21 12:09:22 PM"

?

Copy issue?

Not applicable
Author

Perfect, Thanks