Converting Twitter dates

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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