Help

Re: [SOLVED] Subtracting a Number from a Date not Working

388 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sharon_Clark
5 - Automation Enthusiast
5 - Automation Enthusiast

I am using this code:

DATEADD(2/20/2018, -15, ‘days’)

If I change out the date to reference another column it will work. When I input this, all I get are #ERROR messages. What am I doing wrong?

2 Replies 2
Anneka_K
5 - Automation Enthusiast
5 - Automation Enthusiast

I had this same problem yesterday! You just need to put single quotes around the date:

DATEADD('2/20/2018', -15, ‘days’)

Sharon_Clark
5 - Automation Enthusiast
5 - Automation Enthusiast

It works! Thank you!