Dates with later times, when referenced elsewhere, show as one date later


#1

I have a tab that I’m using as a calendar. I have the date field configured to also show a time. All my events are either 1:30pm, 2:30pm, 6:30pm or 7:30pm.

In another tab I have a lookup field that references data from the calendar tab. Whenever it references a record with a time that is 6:30 or 7:30, it lists the date as one date later. In the calendar tab, the date shows correctly. But when the date is listed elsewhere, it shows incorrectly. How do I fix this?

See photos below: in the Calendar photo, the event called “Knox Show Preview 1 (All)” is on 11/21. In the Show Reports photo, the same event is on 11/22.


#2

make sure the “use same timezone” toggle is selected for your lookup field.