Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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

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

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