extracting information from a field

Thu, 10 May 2012 23:00:28 GMT

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,

Oleg_Troyansky — Fri, 11 May 2012 02:10:49 GMT

I think you should first convert the string to the timestamp, and then you can extract any other formats from the timestamp:

timestamp#(DateString, 'MMMM DD, YYYY mm:ss') as MyTimestamp

Notice the MMMM - that signifies the full spelling of the month names.

topic extracting information from a field in QlikView