Past Due Dates

[JamesJ]

I'm using the following sql to show items dated today +6 days in advance.
How
might I also show items dated prior to Date() (past due items).

SELECT * FROM tblReminders WHERE (((ReminderDate) Between Date() And
Date()+6)
AND ((ReminderTypeID)<3)) ORDER BY ReminderDate, ReminderTime, Reminder;

Thanks,
James

 

[John W. Vinson]

I'm using the following sql to show items dated today +6 days in advance.
How
might I also show items dated prior to Date() (past due items).

Just change it to

SELECT * FROM tblReminders WHERE (((ReminderDate) < Date()+6)
AND ((ReminderTypeID)<3)) ORDER BY ReminderDate, ReminderTime, Reminder;

John W. Vinson [MVP]

 

[JamesJ]

Worked great.

Thanks,
James

Just change it to

SELECT * FROM tblReminders WHERE (((ReminderDate) < Date()+6)
AND ((ReminderTypeID)<3)) ORDER BY ReminderDate, ReminderTime, Reminder;

John W. Vinson [MVP]