Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys.
Need a script to show the max month of the quarter,
example: Considering Today
For Q1 Mar
For Q2 Jun
For Q3 July
Hello, You can Add :
Month(Quarterend(Date)) as MaxMonth
or use an inline with :
Temp :
Load * inline [
Quarter, QMonth
'Quarter 1', 'Mar'
'Quarter 2','Jun'
'Quarter 3','Sep'
'Quarter 4', 'Dec'];
& then link the quarter with the quarter in your Table & Use the QMonth in the front end where you require.
Regards,
Rohan.