I have a query to select people for a duty, based on a ratio I produced given how long they have worked here and how many duties they have done.
I need to now add to those records a date, 1st to the 30th of the following month (dynamic), so every time the query is run it will do the next month, regardless to what day/month/year we are currently in.
So Mr Record A is on duty on the 1st, Mr Record B is on duty on the 2nd, Mr Record C is on duty on the 3rd...etc
Anyone got any ideas on how to accomplish this?
I need to now add to those records a date, 1st to the 30th of the following month (dynamic), so every time the query is run it will do the next month, regardless to what day/month/year we are currently in.
So Mr Record A is on duty on the 1st, Mr Record B is on duty on the 2nd, Mr Record C is on duty on the 3rd...etc
Anyone got any ideas on how to accomplish this?
