Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

DATEADD formula not working

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1512 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jennifer_Beazer
4 - Data Explorer
4 - Data Explorer

Using the formula for date add as found in AT, I can get the date to SUBTRACT days but not to ADD days.

I have a date column {datereqsent} and I want {duedate} to calculated to 30 days from datereqsent.

I have tried changing the minus sign to a plus sign and that is not working.

TIA

1 Solution

Accepted Solutions
Jennifer_Beazer
4 - Data Explorer
4 - Data Explorer

THANK YOU! :grinning:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Jennifer_Beazer!

Use this formula:

DATEADD(datereqsent,30,'days')

Jennifer_Beazer
4 - Data Explorer
4 - Data Explorer

THANK YOU! :grinning: