Skip to main content

Any idea why this is giving me the same result? I assume this should be a negative number not zero right?![



https://photos.app.goo.gl/vyBy9Ij2WerlK2XF3



Day formula : DATETIME_FORMAT({Meeting Date}, ‘dddd’)


Days Remaining formula: DATETIME_DIFF({Meeting Date}, TODAY(), ‘days’)

What time of day did you test this - it may not have been a full day.

Make sure either all of your dates and formulas resulting in a date are set to use GMT or none of them are. Whenever I find some weirdness in date processing, that’s usually the culprit.

Hello airtable community,



Do you have any idea why my formula equals “-0” ?




I would like to substract a paid amount to a due amount to let me know if i have paid the all amount or if i still have something to pay.



The formula works for the majority of the amounts but for some, it says “-0”


The 2 amounts are exactly the same, there is no other figure after the coma so I don’t understand



Thank you ! 🙂

Reply


Terms & Conditions