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

[#1]

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 · Accepted solution]

Hi,

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

2) Month(date)

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

4) year(date)

BR

Ariel

[#3]

Thank you, it works!