add an integer to Date the get Date?

[aa]

I have a table "Invoices" containing, among other things, the date of the
invoice, as type Date
I have another table "Customers" containing, among other things, the credit
terms for each customer (like 30 days, 60 days etc) as type Integer.

How do I build a query to show the invoice payment due date, i.e. how do I
add an integer to Date the get Date?

 

[Roger Carlson]

Simply add it to the date. A date is stored internally as a Double
precision number, so you should just be able to do:
DueDate: InvoiceDate + 30
You can also use the DateAdd funtion:
DueDate: DateAdd("d", 30, InvoiceDate)

The nice thing about DateAdd is that you can add days or weeks, or months,
or quarters, or a whole bunch of other intervals. But there is no real
advantage when using days.

 

[aa]

Thank you very much

 

[Douglas J. Steele]

This works as Dates are nothing other than numbers for Access, Day 1 =

01/Jan/1900.

<pedantic>
Actually, Day 1 is 31 Dec, 1899. This is because Microsoft decided to
perpetuate an error made in Lotus 1-2-3 to make conversion simpler when they
produced Excel, and they had to keep it to simplify inter-application
operability.
</pedantic>

 

[EDUARDO PICCINI]

I have a table "Invoices" containing, among other things, the date of the
invoice, as type Date
I have another table "Customers" containing, among other things, the credit
terms for each customer (like 30 days, 60 days etc) as type Integer.

How do I build a query to show the invoice payment due date, i.e. how do I
add an integer to Date the get Date?

 

[Tom Ellison]

Dear Eduardo:

Please refer to the DateAdd function in online help or your favorite
printed reference. This has just what you need.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts