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?