how to convert a date prompt into a quarter when the user selects the date

[v2k4u]

how to convert a date prompt into a quarter when the user selects the date.The date should be converted into the querterly data and then i am supposed to calculate the 8 previous quarters data based on the selected date in the date prompt.

[Dineshkumar]

Hi,

Can u explain it more clearly?

-Dinesh

[Mohanakrishnak]

Below Expressions May Helpful to you..

case
when
extract(month,?p_date?) in (1,2,3)
then
'Q1'
when
extract(month,[Date Field]) in (4,5,6)
then
'Q2'
when
extract(month,[Date Field]) in (7,8,9)
then
'Q3'
else
'Q4'
end

And Based on the Quarter You can Go back and take the Previous 8 Qurters.

....etc