Format Date field as Quarter

[jvbeats]

Hi, I am relatively new to Access, I would like to format a date field as a quarter in my query. Not sure how to build the expression.

Thank you.

 

[MarkK]

Hey there, try ...

Month(YourDate)\4 + 1

Cheers,

 

[jdraw]

You could also use

datepart("q",YourDate) returns an integer (I think).

 

[jvbeats]

Sorry. I think what works best is Format([mydate],"q")

 

[MarkK]

Glad to be able to help.

 

[Galaxiom]

Sorry. I think what works best is Format([mydate],"q")

A subtle point that should always be kept in mind.

DatePart() returns a Number while Format() returns a String.

It doesn't matter with Quarter but it makes a difference if you are sorting the output on Month or Day.