Challenge #192: Crane Leasing

[dhtay]

Nice refresher in using

スポイラ

the Generate Rows tool with dates

[RolandSchubert]

My solution.

スポイラ

[Sebenius]

スポイラ

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:

スポイラ

[JamesCameron]

My Effort

スポイラ

[Kucsi]

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

スポイラ

[OllieClarke]

Here's my effort:

スポイラ

[RWvanLeeuwen]

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

スポイラ

[cdavis19]

スポイラ

[mbogusz]

スポイラ

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