I want to find Quarter in which given date falls.Any help is appreciated.
Use a master calendar to create a quarter field and your date will be linked to the quarter field.
Creating A Master Calendar
'Q' & Ceil(Month(TempDate)/3) as Quarter
Just use the quatername() function
For exemple you have a date field called "date"
add this : quatername(date)
Hope it helps
Retrieving data ...