Overview
This How-To will show you how to get the Time Difference in between two date questions.
- Let’s say we have for example two date questions:
-
After both date questions were answered, in order to get the Time Difference in days between them, I would write this function:
Round(TimeDiffDays(Answer(2),Answer(1)));If I answered in question1:
12\23\2012
and in question2:
12\30\2012It will return 7.
The Right parameter is the older date; the Left parameter is the newer date.
The Round function will just return an integer instead of a non-integer number.You can use this returned value wherever you need in your survey
- The time diff function is also valid for seconds\hours\days\months\years, here are the rest of them:
- TimeDiffSeconds
- TimeDiffHours
- TimeDiffDays
- TimeDiffMonths
- TimeDiffYears
Please Note: The first date entered is the later date.
That’s it !
Visit us at: http://www.dooblo.net
Comments
Please sign in to leave a comment.