Lookup Field is Pulling Wrong Date

[Mandy_Hutchison]

HELP PLEASE!!

I have a table with a LOOKUP FIELD, pulling a date from another table.

The date in the original table is correct…but the lookup field in the second table is pulling a date one day earlier. I cannot figure why this would be!

Any help is appreciated.

[ScottWorld · Accepted solution]

It’s because your time zone settings are not the same on both fields. Go into the customize screen for both fields, and make sure that the time zone settings match.

[Mandy_Hutchison]

:woman_facepalming: Thank you!

[ScottWorld]

You’re welcome! Glad I could help! :slightly_smiling_face: