date criteria

[quinnb]

Hi i am running a query to pick up upcoming dates - a remider letter to be sent out when its 30 dAYS in the future
BUT the database may not be used every day and i am scared an upcoming date will be missed - so how do i set a criteria of viewing dates between 24 & 30 days so this can be ran once per week as a task - so reminders sent out 30 days max to 23 days min (which is still a fair bit of time)


Thanks

[pbaldy]

Use Between, the DateAdd() function and the Date() function.

[quinnb]

Thankyou but can you give me the exact criteria pleaase - so weekly task - MOTS due between 24 and 30 days from now thanks

[ArviLaanemets]

1. In case you have back-end database on SQL Server (not SQL Server Express): A job runs once in a day, and executes a stored procedure, which queries database for entries due to reminder, and sends out e-mails;

2. In case you have back-end database on SQL Server Express: a sheduled task runs once in a day, and executes a stored procedure in SQL Server Express database - further look p.1;

3. In case you have splitted/nonsplitted database in MS Access entirely: You can use Windows sheduled task (on computer/server where your database is stored) to start your application (to avoid any surprises sometime at night), run a procedure there, and when procedure finishes, then close the application.

I have used SQL Server jobs to send e-mails and SMS'es (to send out messages about production breakdowns automatically). I also have used Windows sheduled tasks to run pass-trough queries to get data from dbf-files (we have 64-bit SQL Sever, which doesn't have - and it looks lik it will not have it ever - FoxPro ODBC Driver, so we set up a 32-bit SQL Server Express for reading data). I have used sheduled tasks to activate Access database and to run a procedure there some 10 yeas ago - so I know at least, that it is possible too.

[pbaldy]

Does this help?

DateAdd("d", 24, Date())

[quinnb]

Does this help?

DateAdd("d", 24, Date())

Thankyou it does

[quinnb]

Sorry it didnt help - that just gives me 24 days in to the future - i would like 24 to 30 days please??

[pbaldy]

That was to give you the idea. It would be

Between DateAdd(...) And DateAdd(...)

[quinnb]

Sorry i am being very thick i know - but entering that just gives me error messAGE
what is the exact criteria please for 24 to 30 days?

[pbaldy]

I've given you the overall structure and an example of the syntax for the DateAdd() function. All you need to do is put them together, and make the second one 30 instead of 24 days.