Returning a found set based on a number of days from date in a date stamp field
Its nice to be back doing FM work, it's been a long while since I've been on the forums!
The kids who work in our college department call applying kids to see if they will turn up to an audition.
I want to the find script to only include kids who received a notification 2 weeks or more from a set invitation datestamp field and then separately I want another script to find records 3 weeks prior to a set datestamp audition field.
The script has me stumped at this point as I can't figure out how to find in a datestamp field a number of days from the date in it. I know the field sees time in seconds but obviously the find can't perform a calculation:
Enter Find Mode
Set Field [SQL_table::Date_of_audition_stamp; $Invite_date + (86400 * 14)]
Does anyone have any tips?