AnsweredAssumed Answered

Returning a found set based on a number of days from date in a date stamp field

Question asked by oisinmcauley on Oct 15, 2013
Latest reply on Oct 15, 2013 by philmodjunk

Title

Returning a found set based on a number of days from date in a date stamp field

Post

       Hi there, 

     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)]

     Perform Find

     Does anyone have any tips?  

     Thanks!

      

     Oisin

Outcomes