How to find in which Quarter the given date falls.

[berryandcherry6]

I want to find Quarter in which given date falls.Any help is appreciated.

Thanks,

Supriya

[sunny_talwar · Accepted solution]

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

[brunobertels]

Hi

Just use the quatername() function

For exemple you have a date field called "date"

add this : quatername(date)

Hope it helps

Bruno