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?