| Panel | ||
|---|---|---|
| ||
Average |
...
DateDiff('yesterday', ‘now', 'm‘m')
This calculates the total minutes between yesterdays yesterday’s date (parameter 1) and the date and time right now (parameter 2).
If the yesterdays’ yesterday's date is 07/10/2023 and we are evaluating this function at 07/11/2023 at 4:07pm then the result should be about: (in minutes) should look like: ‘yesterday’ (Parameter 1) minus ‘now’ (Parameter 2) = -2407.5039294216667
Using DateDiff to change stages:
...
The “FinalStage” stage is Time Based and will only be active for 1 day (24 hours) since the stage does not end at midnight.
...
| |||
|---|---|---|---|
Current Date | Question Variable | Result | Interpretation |
today = 04/17/2024 | study_startdate = 04/17/2024 | 0 | False - stays in current stage |
today = 04/17/2024 | study_startdate = 04/12/224 | 5 | True - transitions to next stage |
...