If I need to add 10 days to a DateTimeDiff result, should the following work?
DateTimeDiff(dt1,dt2,"days") + 10
Solved! Go to Solution.
Hi @johneodell if you field is a numeric field though adding 10 should work.
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.
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?
@JosephSerpis That was it! One of my dates was formatted incorrectly. I just needed an outside perspective. Thanks!!