Querying by date

[chiodde]

I am attempting to create a sql query that generates all records whose 'date due' field is 3 days after today (i.e will show all projects (records) that are due in three days time). I have ben experimenting with DATEDIFF() function, but to no avail.

I am reasonably inexperienced with these computer things and would appreciate any help offered.

Many thanks
dave (new and desperate member)

 

[David R]

The function you've been hunting for is DateAdd().
Your SQL WHERE clause should be:
WHERE (([Source].[DateDueField]) Between Now() And DateAdd("d",3,Now()))
(for all projects due in the next three days, including today)

Alternatively, you CAN use DateDiff() if you want. You'll have to add a calculated field though: DateDifference: DateDiff("d",[DateReceived],Now())
And then in the Criteria: <3

And then remember not to show that field and add your real date field back in. Which is why I go with DateAdd().

HTH,
David R




[This message has been edited by David R (edited 02-07-2002).]

 

[chiodde]

Dave,

Thank you very much for the time and effort spent on replying to my question. I have not yet tried your suggestion, but will let u know when it is working.

Thanks again
dave

 

[chiodde]

RE: dateAdd() function.

David,

Works a treat! Thanks again.

Dave