Dates in Journal Entry Reports one Day off

Forum|Forum|1 year ago
June 25, 2024
2 replies
1316 views

Hello community. It has been recently realized by our users that all the Dates referenced in our Journal Entry reports are showing one day earlier than when they actually are in the Project.

For Example, I have a field "Print On Sale" that is a Date Field. when Creating the Project, I put 11/1/24 as the Date in that field. However in my Journal Entry report is whows the Field was Added, and the "New Date" value is 10/31/24.

Anyone else seeing this problem? Apparently this has been happening for a bit, and the user I am working with says she felt it started around Day Light Savings time Is that possible?

In my attached screen grab, you can see that on top is my Journal Entry report showing the Field "DE:printONSale" was added and the New Date is 10/31/24 however on the bottom, I have the System Updates showing the field "printOnSale" field was changed to 11/1/24.

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

KellieGardner

Community Advisor

Do you use multiple schedules or time zones in Workfront? If so, this will impact how dates show for users with differences. I would venture to guess it has something to do with that and you could start there to see if that's what is causing it?

J

JyotiNa

Level 2

I have similar issue with My Journal report too. Here's some additional information i think will help to identify this issue..

My Instance is set in Eastern timezone

When change the date format in my report to show hours as well, it is saying 8pm for everything. The issue: This report in Workfront is reading the date input in the "DE:Market Date" field and thinking that it is in UTC/GMT instead of Eastern Time.

For example, the "DE:Market Date" date has the value 6/25/2024 12:00am ET. In the project it stays displaying as 6/25/2024 because it is correctly showing it in ET. In the Journal report, Workfront thinks that the value input is 6/25/2024 12:00am UTC/GMT instead of ET. It displays the value to me in ET, which changes it to 6/24/2024 8:00pm (because ET is -4 hours from UTC/GMT). Seem to be a bug.

Y

yearianaAuthor

Level 2

Interesting. I wonder what would happen is we change the Workfront INstance to UTC time? I could test that in our SandBox environment I suppose.

Y

yearianaAuthor

Level 2

I liked the UTC vs. EST time zone issue. However I realized though that when I first run my Journal Entry report the date is actually Correct. Then when I run it two min. later it is not. See my screen shots.

I updated the field to be 11/3/24. Then immediately ran the change report on the left you can see it was updated to 11/3. Then I simply waited two minutes. and refreshed the data on the report without making any changes to the project. You can see on the right now it says 11/2/24. The Changed on Time is exactly the same.

skyehansen

it would be best if you take a recording of this behavior and submit a case to Support.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded