Challenge #258: Relatively Old

[Sivashankaran]

Here is my solution for the Challenge #258

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

2. Convert the DOB to custom format “%A” to see its appropriate Weekday.

[christopher_ontkean]

Solution

[aiahwieder]

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

[pclane]

Good challenge for learning about DateTime functions

[Dibas98]

Fun

[SihanL]

258

[holly_jones12]

Spoiler

[leefurches]

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

[JakubJ]

Hi, it is my solution. Regards

[Amanda_Vinduska]

Fun!