AnsweredAssumed Answered

Script to find records 30 days in past

Question asked by redsonya511 on Mar 17, 2017
Latest reply on Mar 20, 2017 by redsonya511

I have three date fields that I need to search to find records that had interviews scheduled in the past month so I can make sure the interviews actually went forward. 

 

I have to search the First Interview Date, Second Interview Date and Third Interview Date fields but I'm not sure how to write a script to search for dates that are specifically 30 days past.  For instance: today, i would want to know only the interviews that happened on or before today but after 2/15/17. Tomorrow, I would want to know only the interviews that happened on or before tomorrow's date but after 2/16/17.  Does that make sense?

Outcomes