This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackBlake,
Hey I liked the Video. Would have been tough to do that otherwise!
C225 was solved! thanks
Nice introduction into Interface tools
This was a great little app challenge. I can't wait to do this one with the user community at work!
My solution differs slightly from the provided solution on the weeks calculation, as I did not count partial weeks. For example, at 7:53 AM on 7/28/2020, I ran the provided solution, choosing 7/22/2020 as the start date. The solution gives weeks=1, although it was only six complete days (my solution would count this as zero weeks to be consistent with how we are handling partial years and months).
Not sure if this is the right way to do it but still gave it a try (My first Challenge)
IF '%Question.List Box%'= 'Year' THEN DateTimeDiff(DateTimeToday(),ToDateTime('%Question.Date%'),'years')
ELSEIF '%Question.List Box%'= 'Month' THEN DateTimeDiff(DateTimeToday(),ToDateTime('%Question.Date%'),'months')
ELSEIF '%Question.List Box%'= 'Days' THEN DateTimeDiff(DateTimeToday(),ToDateTime('%Question.Date%'),'Days')
ELSEIF '%Question.List Box%'= 'YearMonth' THEN 'Year: ' +ToString(DateTimeDiff(DateTimeToday(),ToDateTime('%Question.Date%'),'years'), 0) + ' ' + 'Month: ' +ToString(DateTimeDiff(DateTimeToday(),ToDateTime('%Question.Date%'),'months'),0) ELSE 0 ENDIF