hi,
i have the follwoing script in my calender
Upper(Month(monthstart($(TimeField)-26,1))) as Month,
how can i get my quarters code to follow this logic?
Dual('Q'&Num(Ceil(Num(Month($(TimeField)))/3)),Num(Ceil(NUM(Month($(Timefield)))/3),00)) as [Quarter],
I HAVE TTRIED THE FOLLOWING
Dual('Q'&Num(Ceil(Num(Month($(TimeField)-26,1))/3)),Num(Ceil(NUM(Month($(Timefield)-26,1))/3),00)) as [Quarter],
best
BRAD