1 Reply Latest reply: Sep 25, 2012 6:39 AM by Brian Murphy RSS

    How to extract days or months from the Twitter-timestamp?

      Hi all,

       

      I'm new with Qlikview and just started learning to use some regular expressions etc. I'm building my own social dashboard (with the QVsource connectors). All looks/goes well, ecxept for one thing:

       

      When I load a search with the Twitter conector, I receive a colom called 'created_at' containing a timestamp with the following format:

       

      Fri, 06 Apr 07:45:47 +0000

       

      I tried to create a selection-table  with it by selecting the field and changing the format into date, but nothing happens. How can I extract a selection-table with only the days or months?

       

      Can anyone help me out?

       

      Regards,

      Sebastian