Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Pull Planned Completion Date "Time" for a report / calendar.

Avatar

Level 2

We currently have a calculated field to pull the Planned Completion Date "time" for email deployments. It displays in 24:00 but suddenly it has stopped functioning properly and adds 4 hours to every Planned Completion Date "Time".

 

CONCAT(HOUR({plannedCompletionDate}),":",RIGHT(CONCAT('0',MINUTE({plannedCompletionDate})),2))
 
I did not change this calculation and it has been working fine for a couple years.

 

So if the Planned Completion Date is = Oct. 31, 2022 9:00 AM the Deployment Hour should be 9:00 but in some cases it is 13:00.

 

Screenshot for reference.

 

Screen Shot 2022-10-28 at 1.08.34 PM.png

Any help or suggestions would be appreciated. Thank you!

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I'm not sure I understood your response, so just to clarify --

 

* are your calculated times (created after 22.4) all 4 hours off without exception?

* is your timezone 4 hours different from UTC? (or more to the point, what is your timezone)

 

My initial reaction would be that if it's all 4 hours off, maybe you should just subtract 4 hours from your calculation. However, this is mainly because I don't really work with time/timezones. 

View solution in original post

3 Replies

Avatar

Community Advisor

Before I look into your question more deeply, are you aware that the recent product release mentioned a chance to calculated fields in that they now calculate in UTC? Would this have had an effect on your calculations?

 

https://experienceleague.adobe.com/docs/workfront/using/product-announcements/product-releases/relea... (word search for UTC)

Avatar

Level 2

Thank you. I missed that completely.

 

I did some investigating and didn't find anything that was helpful. Do you know if there is a way to correct the calculated field so we could see the time in our time zone? I didn't look it but thought I would ask.

 

Thank you again,

Dawnmarie

Avatar

Correct answer by
Community Advisor

I'm not sure I understood your response, so just to clarify --

 

* are your calculated times (created after 22.4) all 4 hours off without exception?

* is your timezone 4 hours different from UTC? (or more to the point, what is your timezone)

 

My initial reaction would be that if it's all 4 hours off, maybe you should just subtract 4 hours from your calculation. However, this is mainly because I don't really work with time/timezones.