Increment by quarter?

[Ron]

I know I can format a date field to "q" which will show
me what quarter the date is in, however what I'm trying
to do is increment a date quarterly.

I have a group of accounts that are reviewed quarterly
and I need the "next review date" calculation to show
Jan 1, April 1, July 1, or Oct 1. Basically the first one
greater than or equal to Date().

Suggestions?

Thanks,
RT.

 

[Connie]

-----Original Message-----
I know I can format a date field to "q" which will show
me what quarter the date is in, however what I'm trying
to do is increment a date quarterly.

I have a group of accounts that are reviewed quarterly
and I need the "next review date" calculation to show
Jan 1, April 1, July 1, or Oct 1. Basically the first one
greater than or equal to Date().

Suggestions?

Thanks,
RT.

I downloaded a Microsoft Knowledge Base Article #88657
which gives information on displaying specific dates - one
of which is "The first day of the current quarter" and
also "the last day of the current quarter". Hope this
helps.


This is the Last Day of the current quarter.
DateSerial(Year(Date()), Int((Month(Date()) - 1)/3)*3+4,0)


This is the First Day of the Curretn Quarter
DateSerial(Year(Date()), Int((Month(Date()) - 1/3) * 3+1,1)

 

[ron]

Thanks for the reply Connie.

I think your code is going to get me on the right track.
Clever little trick taking the Int number divided by 3.

I had been unsuccessfully trying:
DateAdd("q",[dateq],(DateSerial(Year(Date()),1,1)))

Where [dateq] was a subquery formatting Date() to "Q".

But I don't think it liked the nested DateSerial.

RT.