Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #258: Relatively Old

Sivashankaran
7 - Meteor

Here is my solution for the Challenge #258

Sivashankaran_0-1706958310362.png

 

 

  1. Below is the formula used to find DOB for whole family

if [Name] = 'Kevin' then

 

DateTimeAdd(DateTimeAdd('2015-05-05',-2,'year'),-53,'days')

elseif [Name] = 'Stéphane' then

DateTimeAdd('2015-05-05',7,'days')

elseif [Name] = 'Christine' then

DateTimeAdd(DateTimeAdd(DateTimeAdd('2015-05-05',7,'days'),-25,'year'),-3,'months')

elseif [Name] = 'Samuel' then

DateTimeAdd('2015-05-05',-4,'days')

elseif [Name] = 'Juliette' then

DateTimeAdd('2015-05-05',10,'days')

else

[Date of Birth]

Endif

  1. Convert the DOB to custom format “%A” to see its appropriate Weekday.
christopher_ontkean
8 - Asteroid

Solution

aiahwieder
8 - Asteroid

Reminds me of an old brain teaser/logic puzzle from elementary school!

pclane
6 - Meteoroid

Good challenge for learning about DateTime functions

Dibas98
8 - Asteroid

Fun

SihanL
6 - Meteoroid

258

holly_jones12
7 - Meteor
Spoiler
image.png
leefurches
7 - Meteor

I don't work with date/time much, so hardest one yet!

JakubJ
7 - Meteor

Hi, it is my solution. Regards

Amanda_Vinduska
7 - Meteor

Fun!