Challenge #186: Drilling down into Data Analysis

[mgaronson]

Spoiler

 First instinct was to generate rows for every date after determining the Replaced Date. Checked a few solutions and realized that is not necessary - just check if date from the data files falls between Install and Replace Dates.

[Bobbyt23]

Good challenge, took me a while to get my head around the data.

[lwolfie]

The description in the hint was off.  But I got there.

[tammybrown_tds]

I had to peek at the solution because I couldn't figure out what the challenge was asking.  I still don't really understand it very well.

Spoiler

[Carolyn]

Solved! The hint said to use the day before the Install Date as the Removal Date, but the answer within the Start File wanted the actual Install Date as the Removal Date

Spoiler

 

[cmoussa]

[BSilverblatt]

Solution attached:

[alexnajm]

Done!

Spoiler

[JBevan89]

My Solution attached.

[RebekaMazuchova]

:)