Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

Hi,

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

2) Month(date)

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

4) year(date)

BR

Ariel

View solution in original post

2 Replies
ariel_klien
Specialist
Specialist

Hi,

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

2) Month(date)

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

4) year(date)

BR

Ariel

Not applicable
Author

Thank you, it works!