Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution for the Challenge #258
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