Reference field showing different date/time in list view and form view

[prasad8]

I have created a new Cab date (reference field) on change form and reference to "Cab_meeting " table. In Cab meeting table "meeting start time" field made as display true for displaying meeting start dates in reference field and it is showing all the list of meeting start dates.

When i go to change form and select any meeting start date it is showing correct date and time. If i see in the same record data in LIST view cab date field is showing next day. my instance is in US pacific time zone.

In the form the date/time is "2022-07-14 20:00:00" and in LIST view it is showing "2022-07-15 01:00:00". I can see 5 hours time difference between form and LIST view.

Can any one help me why it is displaying different dates.

[Allen Andreas]

Hi,

On the form, it looks to be showing the display value relevant to you, and then on the record, in list view, so in the database, it's showing the UTC value which is how ServiceNow saves date/times.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[prasad8]

Hi @Allen Andreas ,

Thanks for reply.

Incase if client want report, it is showing wrong data. Is there any solution to correct it.

Thanks,

Prasad.

[Allen Andreas]

Hi,

Unfortunately, I don't think there is. I believe the problem is that this field isn't a date/time and instead, you are referencing another table.

You may want to revisit your approach with this solution.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Community Alums]

You found any solution for this?