3 Replies Latest reply on Oct 15, 2013 10:47 AM by philmodjunk

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

    oisinmcauley

      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