Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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
Miguel_Angel_Baeyens

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