Help

Date Formula Subtracting A day

Topic Labels: Data
Solved
Jump to Solution
613 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Eric_Bryant1
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

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? 

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

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!