Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you please provide an example?
Just try with QuarterName(YourDate).
Can You provide some more details?
Hi,
1 Example:
='Q' & Ceil(Month(Today())/3) & '-' & Year(Today())
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