Todays Date + 30 2

[Elvis72]

Oh if it were soooo easy....

I have found the posts for the Date()+30,
but I have a problem using it.

My Mobilization and Demobilization Dates are based on a table of dates that are formatted as such:

6/1/2008
7/1/2008
8/1/2008
9/1/2008
10/1/2008
thru 2025

What I need to do is take todays date 6/23/2008 and add 30 days to see who is going to be Demobilizing in the next month.

But because my dates are based on the 1st of the month its not working?

Here is the query:

SELECT QryCounstructionServices3.JobProposalNo, QryCounstructionServices3.TitleID, QryCounstructionServices3.WorkerID, TblStaffRequirements.[Position Title], QryCounstructionServices3.[Mobilization Date], QryCounstructionServices3.[Demobilization Date]
FROM QryCounstructionServices3 INNER JOIN TblStaffRequirements ON QryCounstructionServices3.TitleID = TblStaffRequirements.TitleID
WHERE (((QryCounstructionServices3.[Demobilization Date])=Date()+30))
ORDER BY TblStaffRequirements.[Position Title];

Thanks so much for your time and efforts!~

 

[SkipVought]

Hi,

"...my dates are based on the 1st of the month ..."
Add ONE MONTH...

DateSerial(Year(Date()),Month(Date())+1,1)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

Perhaps this ?
WHERE QryCounstructionServices3.[Demobilization Date]=DateSerial(Year(Dare()), 1+Month(Date()), 1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886