1 Reply Latest reply: May 10, 2012 10:10 PM by Oleg Troyansky RSS

    extracting information from a field

      hi,

       

      i have this kind of format in a field

       

      MM DD, YYYY hh:mm

      January 29, 2011 12:00

      February 29, 2011 12:00

      March 29, 2011 12:00

      April 29, 2011 12:00

      May 29, 2011 12:00

      June 29, 2011 12:00

      July 29, 2011 12:00

      August 29, 2011 12:00

      September 29, 2011 12:00

      October 29, 2011 12:00

      November 29, 2011 12:00

      December 29, 2011 12:00

       

      what changes do i have to do in the follow qlikview variables to extract month, year and day independently or how i can extract this information?

       

      TimeFormat

      DateFormat

      TimestampFormat

      MonthNames

       

      thanks,