Notifications

5 views

Description

When creating the PPM status report , the Status Date populated on the form is not current (today's) date ,

for eg : If the instance timezone is set to anything else than UTC , this is experienced

AEST/AEDT : Form will show yesterday's date on "Status Date" until 10AM AEST / 11 AM AEDT , post which it will show current date as expected

IST : Form will show yesterday's date on "Status Date" until 5:30 AM IST , post which it will show current date as expected

 

 

 

Release or Environment

All Release

Cause

1. The column "Status Date" (i.e "as_on") on table "project_status" is having a default value as following
javascript:new GlideDate().getDisplayValue()

2. GlideDate().getDisplayValue() is returning the date in the UTC timezone and hence will show the date as per UTC timezone and not as per Session timezone.

3. This issue is related to PRB619500 (GlideDate.getDisplayValue() uses the UTC timezone instead of user's timezone)
The DEV has confirmed on the Problem that this is working as designed. This behavior is explained further on Knowledge article https://hi.service-now.com/kb_view.do?sysparm_article=KB0725708

Resolution

Update the default value script on the dictionary record (for column "Status Date")  to the following and this should resolve the issue.

javascript:new GlideDateTime().getLocalDate().getDisplayValue()

Additional Information

KB0725708

Article Information

Last Updated:2020-03-08 16:49:58
Published:2020-03-08