Formula problem?

[Ali_Aboutera]

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’)

[Julian_Kirkness]

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

[W_Vann_Hall]

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.

[Anais_Laurent]

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 ! :slightly_smiling_face: