Skip to main content

[SOLVED] Subtracting a Number from a Date not Working

S

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

    A
    • Anneka_K
    • Participating Frequently
    • 7 replies
    • February 8, 2018

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

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

    S
    • Sharon_Clark
    • Author
    • New Participant
    • 2 replies
    • February 8, 2018

    It works! Thank you!

    Reply


    Most helpful members this week

    Terms & Conditions