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.
