topic Re: Convert a Date into Day, Quarter, Month, Year? in QlikView

Convert a Date into Day, Quarter, Month, Year?

dmohanty — Tue, 01 Apr 2014 10:21:33 GMT

Hi All,

I have date field in this format: DD-Mon-YY. For example: 24-Oct-2013.

From this I need to fetch, Day, Quarter, Month and Year.

How to do it in script level? Please help.

Regards!

MK_QSL — Tue, 01 Apr 2014 10:24:16 GMT

Use below in your script...

Date(Date#(Date, 'DD-MMM-YYYY') ) as Date,

Month(Date#(Date, 'DD-MMM-YYYY') ) as Month,

Year(Date#(Date, 'DD-MMM-YYYY') ) as Year,

Day(Date#(Date, 'DD-MMM-YYYY') ) as Day,

'Q' & Ceil(Month(Date#(Date, 'DD-MMM-YYYY') ) /3) as Quarter

its_anandrjs — Tue, 01 Apr 2014 10:26:50 GMT

Day(Yourdatefield) as Day

Month(Yourdatefield) as Month

Year(Yourdatefield) as Year

'Q' & Ceil(Month(Yourdatefield) ) /3)

Hope this helps

dmohanty — Tue, 01 Apr 2014 10:34:05 GMT

Thank you Manish and Anand for the quick help!!

its_anandrjs — Tue, 01 Apr 2014 10:35:53 GMT

Or another way also

Year(Date#('24-Oct-2013','DD-MMM-YYYY'))

Month(Date#('24-Oct-2013','DD-MMM-YYYY'))

Day(Date#('24-Oct-2013','DD-MMM-YYYY'))

'Q' & Ceil(Month(Date#('24-Oct-2013','DD-MMM-YYYY'))/3)

Hope this helps