I am having my respondents enter in a specific date, and I would like to create a variable that subtracts 4 weeks from the date, and also adds 12 weeks to that date. I can seem to figure out a way with logic/variables. For example if they enter 2/1/22...I would like to create variables that would calculate to 01/04/22 and 04/26/22 that I can use later in a statement. (subtracting 4 weeks and adding 4 weeks).
Answer
Add or subtract time to date variable
Best answer by john.desborough
Working with a client now to track time spent on a series of quiz questions and it is split into two form so that we capture email and name in first form and the time stamp on submission - redirect to the timed quiz - capture the timestamp on submission of the second form. This allows me to get the duration by subtracting the first time stamp from the second.
The same works for dates - ask for date and then add the number of days before and after to give the results in the original example above. then send out the report..
des
+5Oh, this is a good question
+6- Certified Partner & Champion
- Answer
Working with a client now to track time spent on a series of quiz questions and it is split into two form so that we capture email and name in first form and the time stamp on submission - redirect to the timed quiz - capture the timestamp on submission of the second form. This allows me to get the duration by subtracting the first time stamp from the second.
The same works for dates - ask for date and then add the number of days before and after to give the results in the original example above. then send out the report..
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Thanks very much for the replies, looks like only way is post quiz through google sheets. Thanks again
+5Let us know how it goes for you,
Life is a series of awkward moments separated by snacks.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.