Help

Formula problem?

1723 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ali_Aboutera
6 - Interface Innovator
6 - Interface Innovator

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

3 Replies 3

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.

Anais_Laurent
4 - Data Explorer
4 - Data Explorer

Hello airtable community,

Do you have any idea why my formula equals “-0” ?
Capture d’écran 2022-04-13 145730

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: