What value are you putting in $Invite_Date? if this is a date, you need to multiply it by the number of seconds in a day as dates record their value as the number of days since 12/31/0000.
Thanks for responding!
I used Set Variable to set it to the date the invites are issued. Do you mean I need to do as follows?
Set Variable [$publish_date sql_table::publish_date_field * 86400]
I was actually thinking of:
Set Field [SQL_table::Date_of_audition_stamp; ( $Invite_date + 14) * 86400 ]
But that only specifies a single Timestamp in the future. Frankly, this looks like a search that:
1) should be performed on a date field instead of a time stamp field.
2) probably needs to include either a date range or an additional operator so that you actually find:
Dates from date1...date2, all dates on or before this date, or some such....