Skip to main content
Solved

Date Formula Subtracting A day

  • February 6, 2023
  • 2 replies
  • 114 views
Forum|alt.badge.img+3

Hi,
Am using a formula I've used in bases before, but it's behaving strangely.  It's subtracting a day off of the returned value.  


I have two fields with dates.  Only one of the two will ever have a date in it.  I want the formula to grab the date from whichever field has a date already populated in it (from another table)
Here is the formula.  

IF({Shoot Date Rollup (From Scenes)}="", {Shoot Date Rollup (from Set List)}, {Shoot Date Rollup (From Scenes)})

Example:
Shoot Date Rollup (From Scenes) = 7/25/23
The formula Returns 7/24/23
Same if it's the other field that has data 
Shoot Date Rollup (from Set List) = 8/10/23
Formula field returns 8/9/23

Thanks for any help.

Best answer by TheTimeSavingCo

Feels like a timezone issue.  Could you try looking through all of your source data fields and check whether they're all set to the same timezone? 

View original
    This topic has been closed for replies.

    2 replies

    TheTimeSavingCo
    Forum|alt.badge.img+32

    Feels like a timezone issue.  Could you try looking through all of your source data fields and check whether they're all set to the same timezone? 

    Adam, Airtable Consultant - https://thetimesaving.company
    Forum|alt.badge.img+3
    • Eric_Bryant1
    • Author
    • Participating Frequently
    • February 7, 2023

    Feels like a timezone issue.  Could you try looking through all of your source data fields and check whether they're all set to the same timezone? 


    It was totally a time zone issue!  thanks for the clue!

     

      Terms & ConditionsAccessibility statement