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

Community Alums
Not applicable

I have created a Start Date Time(reference field) Display value is true .
In another table reference field this Start Date Time field shows different Time i added that table as related list you can see it in image below it shows different timing:

 

 

 

2 ACCEPTED SOLUTIONS

Community Alums
Not applicable

Hi @Community Alums ,

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.

And it's not a issue to fix as this field isn't a date/time and instead, you are referencing another table.

 

View solution in original post

Community Alums
Not applicable

For This issue I created another Field Single line Text field and Made Display as True This is the only work around I found.

View solution in original post

4 REPLIES 4

Community Alums
Not applicable

Hi @Community Alums ,

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.

And it's not a issue to fix as this field isn't a date/time and instead, you are referencing another table.

 

Malte_K
Tera Expert

Hi @Community Alums ,

might be an issue with displaying the time in UTC instead of users local display time.

Could you use the "Show xml" context menu ui action by right clicking on the header of the record or by clicking the hamburger menu on the header?
In the xml view of the record you should find the date time of the field "Start Date Time" in UTC and I think it should show 2024-04-03 16:00:00.

Community Alums
Not applicable

Yes it shows 2024-04-03 16:00:00. But i want display 2024-04-03 09:00:00 for everyone how to fix this

Community Alums
Not applicable

For This issue I created another Field Single line Text field and Made Display as True This is the only work around I found.