Timezone Issues In Different Offices.

[gm355]

We have a Flow to create Tasks for items added to an Excel file located in our Teams group. When I load in the upcoming tasks, they appear fine for me (in Ireland), but for my US colleagues, they see a 1 day lag on some tasks.

We have tried the timezone converter, but didn't have any luck. Any suggestions would be greatly appreciated.

Here is the Flow:

The If statements above are:

if(empty(item()?['Start Date']),null,addDays('1899-12-30',int(item()?['Start Date']),'yyy-MM-dd'))

if(empty(item()?['Due Date']),null,addDays('1899-12-30',int(item()?['Due Date']),'yyy-MM-dd'))

This is the Excel file from Teams:

Thanks.

[alaabitar]

Hello,

When ever you store a datetime you should always store it in utc timezone so that it will display correctly for all users.

Best regards,

Alaa