Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Converting Twitter dates

Hi

I am pulling in dates from Twitter which seem to be in the format:

Fri Apr 01 00:40:57 +0000 2011

Any idea how I can convert this into a date format I can use in QlikView?

Thanks

Jon

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Converting Twitter dates

Hi Jon,

This is quite a large line, but works:

=Timestamp(Date#(SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 2) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 3) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 6) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 4), 'MMMDDYYYYhh:mm:ss'))

Hope that helps and someone finds an easier way to achieve it.

Miguel

View solution in original post

1 Reply
Highlighted

Re: Converting Twitter dates

Hi Jon,

This is quite a large line, but works:

=Timestamp(Date#(SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 2) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 3) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 6) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 4), 'MMMDDYYYYhh:mm:ss'))

Hope that helps and someone finds an easier way to achieve it.

Miguel

View solution in original post