topic Re: Converting Twitter dates in QlikView https://community.qlik.com/t5/QlikView/Converting-Twitter-dates/m-p/399231#M148585 <HTML><HEAD></HEAD><BODY><P>Hi Jon,</P><P></P><P>This is quite a large line, but works:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13474486288856994" jivemacro_uid="_13474486288856994"><P>=Timestamp(Date#(SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 2) &amp; SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 3) &amp; SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 6) &amp; SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 4), 'MMMDDYYYYhh:mm:ss'))</P></PRE><P></P><P>Hope that helps and someone finds an easier way to achieve it.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 12 Sep 2012 11:30:58 GMT Miguel_Angel_Baeyens 2012-09-12T11:30:58Z Converting Twitter dates https://community.qlik.com/t5/QlikView/Converting-Twitter-dates/m-p/399230#M148584 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am pulling in dates from Twitter which seem to be in the format:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="187"><TBODY><TR><TD class="xl63" height="17" width="187">Fri Apr 01 00:40:57 +0000 2011</TD></TR></TBODY></TABLE><P></P><P>Any idea how I can convert this into a date format I can use in QlikView?</P><P></P><P>Thanks</P><P>Jon</P></BODY></HTML> Wed, 12 Sep 2012 11:03:40 GMT https://community.qlik.com/t5/QlikView/Converting-Twitter-dates/m-p/399230#M148584 2012-09-12T11:03:40Z Re: Converting Twitter dates https://community.qlik.com/t5/QlikView/Converting-Twitter-dates/m-p/399231#M148585 <HTML><HEAD></HEAD><BODY><P>Hi Jon,</P><P></P><P>This is quite a large line, but works:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13474486288856994" jivemacro_uid="_13474486288856994"><P>=Timestamp(Date#(SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 2) &amp; SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 3) &amp; SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 6) &amp; SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 4), 'MMMDDYYYYhh:mm:ss'))</P></PRE><P></P><P>Hope that helps and someone finds an easier way to achieve it.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 12 Sep 2012 11:30:58 GMT https://community.qlik.com/t5/QlikView/Converting-Twitter-dates/m-p/399231#M148585 Miguel_Angel_Baeyens 2012-09-12T11:30:58Z