Chat - Report comment date & time always shows Today for public and phone accounts

[kbecciv]

If you haven’t already, check out our contributing guidelines for onboarding and email [email protected] to request to join our Slack channel!

---

Issue found when executing CP #10043

Action Performed:

1. Go to https://staging.new.expensify.com/
2. Log in with public account (gmail) or phone account
3. 1.Go to a report with multiple previous messages
4. .Send a new message, verify the timestamp on that message is displayed accurately
5. Wait a few minutes, refresh the page, verify the timestamps are still all accurate

Expected Result:

Date & Time next to usernames should be accurate

Actual Result:

Report comment date & time always shows Today for public and phone accounts

Workaround:

Unknown

Platform:

Where is this issue occurring?

• Web
• iOS
• Android
• Desktop App
• Mobile Web

Version Number: 1.1.85.6

Reproducible in staging?: Yes

Reproducible in production?: Yes

Email or phone of affected tester (no customers): +15082211196/Feya86Katya, [email protected]/w323052760We

Logs: https://stackoverflow.com/c/expensify/questions/4856

Notes/Photos/Videos: Any additional supporting documentation

Bug5657116_Recording__886.mp4

Screen_Recording_20220721-113422_Chrome.mp4

Expensify/Expensify Issue URL:

Issue reported by: Applause - Internal Team

Slack conversation:

View all open jobs on GitHub

[melvin-bot]

Triggered auto assignment to @aldo-expensify (Engineering), see https://stackoverflow.com/c/expensify/questions/4319 for more details.

[aldo-expensify]

Failed to reproduce, tested with a @gmail.com, @expensify.com and @expensifail.com accounts. I don't have a phone account at the moment to test.

Tested in production and staging.

[thesahindia]

@aldo-expensify, It got fixed by #10043.

[aldo-expensify]

@thesahindia , great! thanks for letting me know :), you saved me a bunch of time .

[kavimuru]

@aldo-expensify Still able to repro with these accounts :[email protected]/Feya87Katya
+15082211196/Feya86Katya

Recording.825.mp4

[aldo-expensify]

@kavimuru thanks for providing those cases, I'll test again!

[aldo-expensify]

yep, confirmed that it still happening with that account. I looked at the messages coming in the request from the server, and the created time is fine there... so it must be something on the front

[aldo-expensify]

There is something weird in the personal details stored for [email protected]

The timezone key is referencing the personal details itself

[aldo-expensify]

This is already coming bad from the server:

[parasharrajat]

It seems like DB needs scrutiny.

[aldo-expensify]

Yep, it is stored in the DB like that

[aldo-expensify]

Reproduced locally and confirmed that the bug that caused this was fixed by the PR: #10043

We just have to take care of the bad timeZones that got saved into the database (will do that next)

[aldo-expensify]

Ok, we corrected the bad timeZone value in the database, the account [email protected] (and others with the same problem) should be working fine now.