# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

## Challenge #225: How Long Has It Been?

6 - Meteoroid

Blake,

Hey I liked the Video.  Would have been tough to do that otherwise!

Alteryx Certified Partner

C225 was solved! thanks

Spoiler
Alteryx Certified Partner

Here the solution.

8 - Asteroid

Nice challenge

Spoiler

8 - Asteroid
Spoiler

Nice introduction into Interface tools

8 - Asteroid
Spoiler
11 - Bolide

This was a great little app challenge. I can't wait to do this one with the user community at work!

Spoiler

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).

13 - Pulsar

here is my solution

Spoiler
8 - Asteroid

Hi,

Here is my Solution

6 - Meteoroid

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