MDB File & Date

[HolyAbsolut]

Hello @ all,

I'm tying to get a automatic reminder for Birthdays from are "MDB" file
The dates are saved into a colum which is also formated as "Date"

As only need to check if Month and Day I tried to use following command
Select * from [Adressbook] WHERE DatePart("m",[Birthday]) = 01 AND DatePart("D",[Birthday]) = 16

This one works fine if I use MDB Viewer Plus. But unfortunally it does not work with Macro Schedular.

Do you know an advise how I can get this work.

Best regards

HolyAbsolut

[Marcus Tettmar]

I think DatePart is an Access/VBA function. It therefore has no context in an SQL query made outside of Access.

Here's an idea: Create a query in Access which chucks out all columns from Addressbook as well as two extra columns which chuck out DatePart("m",[Birthday]) and DatePart("D",[Birthday]). Call these BirthDayMonth and BirthDayDay for example.

Then in your Macro Scheduler SQL query this query instead:

Select * from [YourQueryName] WHERE BirthDayMonth = 01 AND BirthDayDay = 26

Simpler.

[HolyAbsolut]

Hello,

Thanks for your support.

I have done as you decribed an d it works.

Thanks.

Best regard

Maximilian Braun