Quarters and Bi-annuals (is there any easy way)

[paulmcdonnell]

Hi guys,

I want to be able to find the first date of the next quarter and next half yearly point.


I have a listings of subscriptions. Client's can join at any time and select the frequency need to ba able to identify the date of the next Quarter and the date of the next 6 monthly interval..

How do I do this?

For example:

if john subscribed today on a quarterly basis then the next date of his issue would be 01 October (Quarter4).

Datepart("q",date()) gives the quarter number.

But how do I identify which quarter is next and how do i dentify a date?


Hope the access world can help

Cheers.

Paul

 

[paalschau]

I think this is the answer:

DateSerial(Year(Date()), Int((Month(Date())-1)/3)*3+4,0)+1