Skip to main content

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.

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? 

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!

 

Reply


Terms & Conditions