extracting information from a field

[#1]

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]

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.