Calculating Hours by person by projects from date ...

[ler1995]

Hello!

I was recently helped on another post to create parameters for the dateadd function. However, it is not calculating dates correctly. Why? How do I fix this?

Here is my function:

SWITCH(

  Task,

  'Email for photo, new hire survey, and short bio of new hire', DATEADD({Hire Date}, -7, 'days'),

  'Assign desk space for new hire', DATEADD({Hire Date}, -3, 'days'),

  'Give Uniform', {Hire Date},

  'Collect how to contact employee while OOO', DATEADD({Hire Date}, 1, 'days')

)

The complete by dates should be: 12/24, 12/31, 12/28, and 1/1

[Dimitris_Goudis]

Hey @ler1995, 

Please be sure you are using the same timezone in both fields. The issue is on the DateAdd formula, not in Switch. 

Thanks,
Dimitris Goudis