I have a timestamp field that looks like this:
It is being read as text and I've tried using Timestamp# to convert it, but it is still tagged as $ascii $text:
Timestamp#(Replace([timestamp],' GMT ',' '),'WWW MMM DD hh:mm:ss YYYY') as newTS,
Would really appreciate some help with this!
Solved! Go to Solution.
If you want to convert this to other Format Like,
you can use below expression:
Replace Time with your fieldname.
Timestamp#(DATE(DATE#(LEFT(RIGHT(replace(Time, 'GMT',''),21),6)&' '&RIGHT(RIGHT(replace(Time, 'GMT',''),21),4),'MMM DD YYYY'),'MM/DD/YYYY')&' '&SubField(Time,' ',4),'MM/DD/YYYY HH:MMS') as #Timestamp