beginner, question about date calculations

  • Thread starter Thread starter fremacmad
  • Start date Start date
F

fremacmad

I am a beginner at databases, and am wondering if it is possible to calculate
according to the parameters of a start month, and payment cycles such as
montly, bi-weekly and so on the next payment due dates?
If I should be asking my question in some other forum could you please let
me know.

Thank you
 
I am a beginner at databases, and am wondering if it is possible to calculate
according to the parameters of a start month, and payment cycles such as
montly, bi-weekly and so on the next payment due dates?
If I should be asking my question in some other forum could you please let
me know.

Thank you
Click to expand...

Access has quite a few useful date functions that make it easy to calculate
such dates: DateAdd(), DateSerial(), and others. You can find out about them
by opening the VBA editor - type Ctrl-G or open any module in design view -
and searching Help.

Just as an example, to get all records with a date field in the previous
month, you could use a query with a criterion on the date field of
= DateSerial(Year(Date()), Month(Date()) - 1, 1) AND < DateSerial(Year(Date()), Month(Date()), 1)
Click to expand...

or to find the date one month from today you could use

DateAdd("m", 1, Date())

John W. Vinson [MVP]
 
Back
Top