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
Capture.PNG
Alteryx Certified Partner

Here the solution.

8 - Asteroid

Nice challenge

 

Spoiler
etzele_0-1595828871359.png

 

8 - Asteroid
Spoiler
Spalders_0-1595854624621.png

Nice introduction into Interface tools

8 - Asteroid
Spoiler
Challenge 225 2020-07-28.jpg
11 - Bolide

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

 

Spoiler
kelly_gilbert_2-1595937823477.png


 

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

kelly_gilbert_1-1595937720416.png 

 

13 - Pulsar

here is my solution 

 

Spoiler
Capture1.PNGCapture.PNG
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