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

prasad8
Giga Expert

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.

find_real_file.png

find_real_file.png

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

4 REPLIES 4

Allen Andreas
Administrator
Administrator

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!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

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.

 

 

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!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Community Alums
Not applicable

You found any solution for this?