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.