Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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.

1 Solution

Accepted Solutions
ariel_klien
Valued Contributor

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

Hi,

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

2) Month(date)

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

4) year(date)

BR

Ariel

2 Replies
ariel_klien
Valued Contributor

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

Hi,

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

2) Month(date)

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

4) year(date)

BR

Ariel

Not applicable

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

Thank you, it works!

Community Browser