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

[DawnmarieD]

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.

 

Any help or suggestions would be appreciated. Thank you!

[skyehansen]

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)

[DawnmarieD]

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

[skyehansen · Accepted solution]

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.