How do I redefine 1st Quarter in Access

[Guest]

I wish to make the fist Quarter of the year = April 1 to June 30

 

[Guest]

Here is a formula that will do what you want:
iif(datepart("q",dtmSomeDate)-1 = 0, 4, datepart("q",dtmSomeDate)-1)

 

[John Vinson]

I wish to make the fist Quarter of the year = April 1 to June 30

You can generate a calculated field for this definition by
timeshifting the date:

DatePart("q", DateAdd("m", -3, [datefield]))

John W. Vinson[MVP]

 

[Guest]

This might be the right formula but where do enter it?
Step by step please.
Thank you.

 

[Guest]

This might be the right formula, but where do I enter it?
Step by step please. Thank you

I wish to make the fist Quarter of the year = April 1 to June 30

You can generate a calculated field for this definition by
timeshifting the date:

DatePart("q", DateAdd("m", -3, [datefield]))

John W. Vinson[MVP]

 

[John Vinson]

This might be the right formula, but where do I enter it?

I have no idea, because I do not know what YOU want to do with the
value, nor anything about the structure of your table, your form, your
report, or whatever that might be.

John W. Vinson[MVP]