Possibility to create Formulas that use only dates, not time (allow more accurate date comparison across all time zones)
Melanie von Schorlemer
We created custom fields called "Contract Date" and "Date Difference." The "Date Difference" field calculates the number of days between the Due Date and the Contract Date to help us identify any slippage that could cause a delay. However, the formula currently gives an incorrect result because ClickUp formulas include the time component in their calculation. The formula calculates based on a different "shared clock" (GMT), the result could appear to be off by up to 12 hours depending on our location.
I request that there be an option to either allow setting of multiple time zones (for organisations that operate internationally) or exclude the time from the formula to achieve more accurate results.
Log In
Caroline Ginty
Hi Melanie von Schorlemer - can you share the Formula you are using here? Would love to see if we have a workaround for you in the meantime!
Melanie von Schorlemer
Caroline Ginty: This is the formula we use. Please let me know if you need any additional information.
Thanks for your support.