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
DATETIME_DIFF showing Negative Result
+3Best answer by Kamille_Parks11
MAX(0, DATETIME_DIFF({End Date}, TODAY(), 'days'))
+27MAX(0, DATETIME_DIFF({End Date}, TODAY(), 'days'))
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.