Date Value in Planner task is not displaying correcting

(0) Share

Report

Posted on by allan_t

300

I've encountered a minor issue where the date value provided in the Create Task connector, is not being displayed correctly.

Here's display in Planner UI. Due Date is presented as May 9, 2024

In the flow that created this task, the date value was 2024-05-10. I'm puzzled by this behavior. I don't think it's time-zone related because I'm in EST, this flow ran at 11:28am EST, which is still same day for UTC time zone.

Anyone know why this is happening?

All responses (1)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (1)

Report
Re: Date Value in Planner task is not displaying correcting

Hi @allan_t ,

I think your Due Date Time is UTC: 2024-05-10T00:00:00Z in flow, and the EST time adopted in your Planner is to subtract the 5-hour time difference from the time of UTC to 2024-05-09T19:00:00Z, I suggest you are on Start Date Time and Due Date Time is nested with the addHours function, plus 5 hours of time to make up for the time difference, your Start Date Time does not change because of subtracting the time difference of 5 hours 2024-05-08 11:28AM or 2024-05-08 6:28AM.

addHours(Start Date Time,5,'yyyy-MM-ddTHH:mm:ssZ') addHours(Due Date Time,5,'yyyy-MM-ddTHH:mm:ssZ')

Best Regards,

Sunshine Gu