Making a Event after a specific date

[Hallo98]

Hello all , i am trying to make a update record in a table a have after a specific date and ONLY once ( for example 25th of every month )

To be more specific :
I have a table which monitors ( by data entree) the account of several Credit cards and i want at the 25th of every month to make those credits card value = 0 ( like a monthly bank order )

Thx in advance for your help and time
Any help will be apreciated

 

[Samoan]

The day() function can be used on a date to return the day number.

For instance, day(2/1/2004) would return 1 (note I'm using U.S. date format, don't know where you're at). day(5/25/2004) would return 25, etc...

If you wanted to get the day number of the current date, you could use
day(date()).

You could incorporate that into a query:

UPDATE yourtable
SET yourtable.[credit card number] = 0
WHERE day(date()) = 25;

Hope this helps.