Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

extracting information from a field


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?






1 Reply

extracting information from a field

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.

Community Browser