Quarter of Year

[Hanksor]

Is it possible to find what quarter of the year a given date is in? Any
help will be appreciated.

 

[Tom Lake]

Is it possible to find what quarter of the year a given date is in? Any
help will be appreciated.

Add this to a Module (any module) and then use the Qtr function

Function Qtr(d As Date)
Select Case Month(d)
Case 1 To 3
Qtr = 1
Case 4 To 6
Qtr = 2
Case 7 To 9
Qtr = 3
Case 10 To 12
Qtr = 4
End Select
End Function

Tom Lake

 

[RoyVidar]

Is it possible to find what quarter of the year a given date is in? Any
help will be appreciated.

Try for instance with the format function

select format(mydate, "q") as myquarter ...

 

[Hanksor]

Thanks!!! That's what I needed......

Try for instance with the format function

select format(mydate, "q") as myquarter ...