topic Re: How do I convert date to month, quarter, year? in QlikView

How do I convert date to month, quarter, year?

Sun, 01 Sep 2013 13:07:33 GMT

Hi, all,

I have field named date of type date which looks like:

2013-06-19

How do I convert it to:

1.19/06/2013

2.Month named Jun (not 6)

3.Quarter named Q-2

4.Year 2013

Thanks in advance!

Inna.

ariel_klien — Sun, 01 Sep 2013 13:35:49 GMT

Hi,

1) date(date,'DD/MM/YYYY')

2) Month(date)

3) 'Q-' & Ceil(Month(date)/3)

4) year(date)

Ariel

Sun, 01 Sep 2013 14:08:00 GMT

Thank you, it works!