adding points to a table on a time period

[pfenwick]

Can you help we have a data with a list of jobs that scores points, I need to build a query or scirpt that will add 5 points every 30 day fro the date the job was submitted this will help old jobs come the top of the list.

 

[bvan]

int(datediff("d",[YourStartingDate],date())/30)*5

Run this daily in an update query.