Please I am trying to write a query that would be executed every day 10, 20 and 30 of every month but I am facing problem to write it. The query would look like this
select amount,tyep from storedata where day="10/02/2012" for day 10 for example but i would not be free to go an change the day every month.
Thanks I am going to implement this today statement in my query but what happen if the day 10 or 20 is not working day like saturday or sunday? Is it possible to add a feature that would check the day of the week to see if it is not saturday and sunday?
Thanks I would right back to you