Trying to grab database records are older than 14 days.. In the database its stored as date/time.
I am wanting to check only on the date part of the field, so when the cron job runs through daily it only grabs records that are 14 days older than today.
I tried a few methods like:
Which generates an error?Code:WHERE DATE(timeslot) = DATE(NOW(), INTERVAL 14 DAY)