How do I trouble shoot wrong date/time in a created date column?

DianeNelligan24_

I have a sheet that records tenant inquiries. I do not have a date field in the form, I use 'created date' in the worksheet. It's been working fine, except for yesterday. I received two tenant inquiries with days in November and weird times. I'm not even sure how to trouble shoot this.

I went into my date and time settings and that's fine. Where else should I look to correct the problem? This has ever happened to me before.

Thank you for your help with this!

cesbue

That is very odd.

"created date" is a system field. Could you please send screenshots showing the "weird times".

DianeNelligan24_

Screenshot 2024-12-06 094906.png

So the INQ-3 was my test this morning to see if is working properly, and it is. But check out INQ-4, and INQ-5. Those were received yesterday afternoon, but check out the numeration (4 and 5? skipped 3), as well are the date and time stamp. I'm enclosing the email notifications as well.

INQ-4 Notification.jpg

INQ-5 Notification.jpg

Let me know what you think… I'm curious…

cesbue

Yes, thanks for the screenshots.
I imagine you have created a column with the auto number type?
Alternatively, what I can suggest to continue monitoring this issue is to create another column with the modified date, or check the cell history.