Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 21, 2021 10:04 AM
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!
Solved! Go to Solution.
May 21, 2021 10:26 AM
May 21, 2021 10:26 AM
MAX(0, DATETIME_DIFF({End Date}, TODAY(), 'days'))
May 21, 2021 10:37 AM
Works! I appreciate it! :clap: