Add by months

J

James

This is what i have
SELECT Monthly.Service, [Date Serviced],[Monthly]![Date Serviced]+30 AS
[Service Due]
In stead of add the month as (30 days), is there a way i can just add a month?
Any help would be appreciated,
Thanks,
Your Pal
James
 
F

fredg

This is what i have
SELECT Monthly.Service, [Date Serviced],[Monthly]![Date Serviced]+30 AS
[Service Due]
In stead of add the month as (30 days), is there a way i can just add a month?
Any help would be appreciated,
Thanks,
Your Pal
James
Click to expand...


Look up the DateAdd function in VBA help.

SELECT Monthly.Service, [Date Serviced],DateAdd("m",1,[Monthly]![Date
Serviced]) AS [Service Due]
 
J

James

Thanks fredg you're a real pal!

fredg said:
This is what i have
SELECT Monthly.Service, [Date Serviced],[Monthly]![Date Serviced]+30 AS
[Service Due]
In stead of add the month as (30 days), is there a way i can just add a month?
Any help would be appreciated,
Thanks,
Your Pal
James
Click to expand...


Look up the DateAdd function in VBA help.

SELECT Monthly.Service, [Date Serviced],DateAdd("m",1,[Monthly]![Date
Serviced]) AS [Service Due]
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

maintenance job schedule creation re dates 0
Add months to a date 2
Last date 3
Creating Database 2
Adding calander months 1
Scheduling by using dates 2
Calendar in Access? 6
Excel Excel due and overdue date colours 2

Top