Skip to main content

Formula problem?

  • December 8, 2017
  • 3 replies
  • 22 views
A

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

    J
    Forum|alt.badge.img+4
    • Julian_Kirkness
    • Inspiring
    • 485 replies
    • December 8, 2017

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

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • 1386 replies
    • December 9, 2017

    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.

    A
    • Anais_Laurent
    • New Participant
    • 1 reply
    • April 13, 2022

    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:


    Terms & ConditionsAccessibility statement