Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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