Time stamp

[#1]

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

[tresB · Accepted solution]

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,

[MarcoWedel]

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

?

Copy issue?

[#5]

Perfect, Thanks