Adding days to DateTimeDiff

[johneodell]

If I need to add 10 days to a DateTimeDiff result, should the following work?

DateTimeDiff(dt1,dt2,"days") + 10

[JosephSerpis]

Hi @johneodell if you field is a numeric field though adding 10 should work.

[johneodell]

@JosephSerpis 

That's what I thought.  The field type is "Double" so I should be able to just add 10 days, but neither solution is working for me.

[JosephSerpis · Accepted solution]

Hi @johneodell I managed to get it working using your syntax are you creating a new field or updating in your formula tool also is date in the format YYYY-MM-DD?

[johneodell]

@JosephSerpis That was it! One of my dates was formatted incorrectly. I just needed an outside perspective. Thanks!!