How to display Current Qtr ?

[paulyeo11]

Hi All

Below working fine for Display Current Month :-
=Date(AddMonths(today(), -1),'MMM YY')

Below working for display Current Year :-
='S$K' & Chr(10) & date(date#(Year(Today())-0,'YYYY'),'YY') /* Year(Today())

I try to Get Current Qtr using below :-

=Right(year(TempDate),2) & '-Q' & ceil(Month(TempDate)/3)

I dont know how to start.

Paul

[Yousef_Amarneh]

Try the below

=Right(year(TempDate),2) & '-Q' & ceil(Num(Month(TempDate))/3)

[paulyeo11]

Hi Sir

Thank you for your sharing .
Your expression when I place at expression label , it does not display correct info. Also you can use the field name = TempDate , as this expression not place at load script.

Paul

[Yousef_Amarneh]

The expression that I mentioned should be used on the script, however, if you want to get the current quarter in the dashboard use the below

Right(year(Today()),2) & '-Q' & ceil(Num(Month(Today()))/3) 

it will give you 20-Q2

[paulyeo11]

Hi Sir

Thank you very much , I try to modify your script to get 19Q4 , I am unable to get it . Look like Quarter is very tricky.

Paul