All the time stamps in the data are of the format: [Dayname, Date Month Year Time]. For eg: Fri, 14 Jul 2017 00:05:26.
How to remove the dayname and convert this to mm/dd/yyyy and also get time as separate field?
May be this
Date(Floor(TimeStamp#(Trim(Mid(DateField, 5)), 'DD MMM YYYY hh:mm:ss')))
Thanks a lot!
Retrieving data ...