Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
Date(Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT')),'YYYY/MM/DD') as ADate
Try like:
Date(Floor(Timestamp#(gps_conf_Location_Time,'YYYY/MM/DD hh:mm:ss TT')),'YYYY/MM/DD') as ADate
Hi,
can you post some sample date.
Regards,
"2014/the following in my scriot05/21 12:09:22 PM"
?
Copy issue?
Perfect, Thanks