Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to find Quarter in which given date falls.Any help is appreciated.
Thanks,
Supriya
Use a master calendar to create a quarter field and your date will be linked to the quarter field.
'Q' & Ceil(Month(TempDate)/3) as Quarter
Use a master calendar to create a quarter field and your date will be linked to the quarter field.
'Q' & Ceil(Month(TempDate)/3) as Quarter
Hi
Just use the quatername() function
For exemple you have a date field called "date"
add this : quatername(date)
Hope it helps
Bruno