Quarter name in expression

[#1]

hii

i have date column from which i want to extract Quarter in QQ/YYYY format and to be used in an expression in a line chart..Will someone please guide.

Note: the chart is functioning correctly for Year with expression = (Date Column Name) with the expression number format as YYYY.

[prieper]

can you please provide an example?

[rospigliosi]

Just try with QuarterName(YourDate).

Can You provide some more details?

[el_aprendiz111]

Hi,

1 Example:

='Q' & Ceil(Month(Today())/3) & '-' & Year(Today())

[prieper]

If intented as above, would suggest to combine suggestions made by Fer Fer and Camillo and combine with a DUAL-function. Thus Quarters will be sorted:

=DUAL('Q' & Ceil(Month(MyDate)/3) & '-' & Year(MyDate) , QUARTERNAME(MyDate))

HTH Peter