Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: DATETIME_DIFF showing Negative Result

Solved
Jump to Solution
1218 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Hector_J_Carr
5 - Automation Enthusiast
5 - Automation Enthusiast

So im trying to calculate days that are left for a project to end.
Im using
DATETIME_DIFF({End Date}, TODAY(), ‘days’) but some ended projects show -2 (the ones that ended 2 days ago) how can I make them just stay at 0? Maybe an if condition. But Cant seem to find it. Thanks!

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus
MAX(0, DATETIME_DIFF({End Date}, TODAY(), 'days'))

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus
MAX(0, DATETIME_DIFF({End Date}, TODAY(), 'days'))
Hector_J_Carr
5 - Automation Enthusiast
5 - Automation Enthusiast

Works! I appreciate it! :clap: