Timestamp conversion

[insideventures1]

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?

Thanks.

[sunny_talwar · Accepted solution]

May be this

Date(Floor(TimeStamp#(Trim(Mid(DateField, 5)), 'DD MMM YYYY hh:mm:ss')))

[insideventures1]

Thanks a lot!