Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

insideventures1
New Contributor

Timestamp conversion

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Timestamp conversion

May be this

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

2 Replies
MVP
MVP

Re: Timestamp conversion

May be this

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

insideventures1
New Contributor

Re: Timestamp conversion

Thanks a lot!