How to add # of days to a parameter that returns a date?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Reed - 12 May 2005 18:47 GMT

Here's the query:

SELECT CalendarDay
FROM tblCalendar
WHERE CalendarDay>=[Enter Date] AND CalendarDay<[Enter Date]+7 AND Weekday=1

I'm trying to get the next Sunday after the date entered into the
parameter, "[Enter Date]", without requiring the user to input 2 dates. Can
anyone help me with a workable way to implement the above logic?

Thanks,

Bill

Reply to this Message

Marshall Barton - 12 May 2005 20:30 GMT

>Here's the query:
>
[quoted text clipped - 5 lines]
>parameter, "[Enter Date]", without requiring the user to input 2 dates. Can
>anyone help me with a workable way to implement the above logic?

That should be something like this (air code)

AND CalendarDay < DateAdd("d",7 - WeekDay([Enter Date], 2),
[Enter Date])

Signature

Marsh
MVP [MS Access]

Reply to this Message

Bill Reed - 16 May 2005 14:59 GMT

Thank you Marshall! All donations are gratefully accepted.

Bill

Reply to this Message