check db records for dates 11 months or older
Posted: Mon Oct 09, 2006 11:09 pm
Hi,
I have a table that holds a date field, I am wanting to have a script that checks the table for dates that are more than 11 months old, and have it email the data of any matching records.
This will run as a cron job.
I not sure where to start on checking the date field for dates older than 11 months .. any help would be appreciated.
Thanks
I have a table that holds a date field, I am wanting to have a script that checks the table for dates that are more than 11 months old, and have it email the data of any matching records.
This will run as a cron job.
I not sure where to start on checking the date field for dates older than 11 months .. any help would be appreciated.
Thanks