Challenge #225: How Long Has It Been?

A solution to last week’s challenge can be found here. The App Interface

Time! Is it the fourth dimension, or a great unknown? A man-made concept or universal truth? Well we won't be solving those questions this week. Rather, we set our sights on describing the length of time between then and now!

For this week's challenge, create an app that calculates the time that has passed between a user-specified date and the present. The user should be able to select the units of time in which the results are displayed.

challenge_225_start_file.yxmd

challenge_225_solution.yxwz

Apps

Advanced

Intermediate

Interface

Accepted answers

All comments

Blake

Oh man I just realized how many days I've been alive...

Spoiler

Check out my video solution below:

Spoiler

Why shouldn't you tell secrets around a clock?

Spoiler

Because time will tell

challenge_225_Blake.yxzp

Aaron_Harter

Fun challenge if you have the time!

Spoiler

challenge_225_AB Data_Aaron.yxwz

atcodedog05

Pretty straight forward challenge.

Was expecting a more tougher challenge for 225th challenge.

And hoping there is a badge. @AYXAcademy

Spoiler

Cheers and Happy Analyzing : )

challenge_225_atcodedog05_Solution.yxwz

RWvanLeeuwen

Was considering creating many more fields, like the number of Dutch holidays and the number of workdays, but I have yet to find a complete list for this type of purpose so I kept it simple 🙂

Spoiler

challenge_225_start_file - RWvL.yxzp

jasperlch

Spoiler

challenge_225_JL.yxwz

johnemery

Fun challenge problem. Not many people use analytic apps or the interface tools that often, so although this challenge was on the easier side (for me, at least), it will certainly be helpful for others.

Spoiler

Challenge 225 Solution jemery.yxwz

dsmdavid

Spoiler

david_225.yxwz

Brando

It's kinda sad that I'm already 8,939 days old 😞

Also this saved as a macro, but I think that's what this challenge was looking for.

225.yxmc

phottovy

Fun basic app! I only allowed one unit of time but might tweak it to allow multiple items to be selected. V2 is now updated after seeing the App Interface picture in the description.

Also, one suggestion would be to set a default date on the "Date" Interface tool

Spoiler

V2:

Spoiler

Replaced the Drop Down tool with a List Box to allow for multiple selections:

challenge_225_ph_solution.yxwz

challenge_225_ph_solution_v2.yxwz

purnimat

Figured out my age 😉

challenge_225_completed.yxwz

DaisukeTsuchiya

Spoiler

challenge_225_start_file_DT.yxwz

Tony_Castillo

Spoiler

challenge_225_solution_TC.yxwz

OllieClarke

A teensy bit more complicated than I thought it'd be

Spoiler

I wish 'weeks' was a viable datetime unit 😞

App

App

Interface

Output

challenge_225_OC_solution.yxwz

T_Willins

My solution. Includes Dynamic Rename to match the user input. Final Ascent badge achieved!

Challenge narrative did not match results window, so only matched to narrative.

Spoiler

challenge_225_solution.yxzp

RolandSchubert

Spoiler

My solution.

Challenge_225_solution_rsc.yxwz

ggruccio

Fun way to get to 225!

Spoiler

challenge_225_gg_finish.yxwz

bsanders2009

Fun challenge to remember how to build apps!

Workflow:

Spoiler

Interface:

Spoiler

Solution:

Spoiler

challenge_225_finished.yxwz

Kenda

Spoiler

Instead of using action tools all of the time, I like to use workflow constants where I can. I did this here to get the user's selected date.

225ks.yxwz

TonyA

Nothing fancy.

Spoiler

challenge_225_TonyA.yxwz

cplewis90

I had the time of my life solving this challenge! (I did not want to know how many hours I have been alive, but I know now)

Spoiler

challenge_225_CL.yxwz

patrick_digan

Spoiler

1 %Love% reference shortcuts
2 I like that the data cleansing tool can now remove null columns
3 Annoying that DateTimeDiff had all the units built in except weeks?

challenge_225_start_file.yxwz

mbogusz

Spoiler

challenge_225_solution_mbogusz.yxzp

paulfound

Spoiler

challenge_225_paul_found.yxwz

kat

Spoiler

Challenge #225.yxwz

FlorianC

I have used the floor function for the weeks instead of the expected ceiling used in the provided output. It seems to me that the numbers should reflect the whole number of time past and it should not be rounded upwards. This is the standard behaviour of the DateTimeDiff function.