Dates in Journal Entry Reports one Day off | Community
Skip to main content
Level 2
June 25, 2024
Question

Dates in Journal Entry Reports one Day off

  • June 25, 2024
  • 2 replies
  • 1318 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.  

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

2 replies

KellieGardner
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 25, 2024

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?

yearianaAuthor
Level 2
June 25, 2024

We thought maybe the TimeZones had something to do with it.  however In my example.  I am in Eastern Time Zone.  I entered it myself.  And my Workfront Instance is in Eastern Time Zone.  And it is showing incorrect for me.    

We do have users across time zones though.  Eastern, Central, and even in Bangalore India.  

yearianaAuthor
Level 2
June 25, 2024

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
Community Advisor and Adobe Champion
June 26, 2024

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