Challenge #192: Crane Leasing

[dhtay]

Nice refresher in using

Spoiler

the Generate Rows tool with dates

[RolandSchubert]

My solution.

Spoiler

[Sebenius]

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

[ddiesel]

My solution:

Spoiler

[JamesCameron]

My Effort

Spoiler

[Kucsi]

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

Spoiler

[OllieClarke]

Here's my effort:

Spoiler

[RWvanLeeuwen]

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

Spoiler

[cdavis19]

Spoiler

[mbogusz]

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