How do I redefine 1st Quarter in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gemolo - 11 Oct 2006 20:18 GMT

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

Reply to this Message

Klatuu - 12 Oct 2006 15:14 GMT

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

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

Reply to this Message

gemolo - 12 Oct 2006 19:53 GMT

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

> Here is a formula that will do what you want:
> iif(datepart("q",dtmSomeDate)-1 = 0, 4, datepart("q",dtmSomeDate)-1)
>
> > I wish to make the fist Quarter of the year = April 1 to June 30

Reply to this Message

John Vinson - 12 Oct 2006 16:48 GMT

>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]

Reply to this Message

gemolo - 12 Oct 2006 19:56 GMT

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
>
[quoted text clipped - 4 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 12 Oct 2006 20:34 GMT

>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]

Reply to this Message