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.
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

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

Submit Feedback

## Challenge #192: Crane Leasing

8 - Asteroid

Nice refresher in using

Spoiler

the Generate Rows tool with dates

16 - Nebula

My solution.

Spoiler
8 - Asteroid
Spoiler

``````Generate Rows:
DateTimeParse([Start Date], '%m/%d/%y')
[LeasedDate] <= DateTimeParse([End Date],'%m/%d/%y')
DateTimeAdd([LeasedDate],1,'days')​

Filter:
DateTimeYear([LeasedDate]) > 2015
AND
DateTimeYear([LeasedDate]) < 2019``````
13 - Pulsar

My solution:

Spoiler
8 - Asteroid

My Effort

Spoiler
8 - Asteroid

It's harder than it seems (for me sure) 😄

Spoiler
15 - Aurora

Here's my effort:

Spoiler
11 - Bolide

Caveat: if a crane is leased and maintained on the same day, it is leased nontheless 🙂

Spoiler
7 - Meteor
Spoiler
9 - Comet
Spoiler
Note to self: check work in the DateTimeParse formula better because it doesn't give an error whether you use "%d/%M/%Y" (first attempt when trying to go off memory on the Date Time functions syntax), "%M/%d/%Y" (second attempt after reviewing solutions and changing mine in haste), or "%m/%d/%Y" (final working solution).