Allow time-bound queries based on survey submission dates

We wanted to created an automated email campaign that would go out to folks who filled out a survey, but who also happened to already be in our database. In order to do this, we had to add a "Date" question to our survey that was tied to one of our custom date fields, then we created some custom scripts that hid the date picker, and automatically filled out today's date in the background. It was a lot of work and a lot of support hours for something that should be as easy as a query like this: "Submit Date of XXXX Survey falls on or before XX day or days prior to today."

  • Alex Robinson
  • Sep 27 2018
  • Reviewed: Voting Open
Area of the Product Other
Org/Company Name Jhpiego
  • Attach files