Skip to main content
Solved

Lookup Field is Pulling Wrong Date

  • August 19, 2020
  • 3 replies
  • 38 views

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.

Best answer by ScottWorld

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.

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • August 19, 2020

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.


  • Author
  • Known Participant
  • August 25, 2020

:woman_facepalming: Thank you!


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • August 25, 2020

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