Excel Connector dates extract issue (Change from integer to dates?)

Like (0) Share

Report

Posted on 14 Jan 2021 19:28:35 by Sam4

229

Hi I am experiencing something weird reading dates from Excel. For the last months I've been reading dates from excel as strings with integer so, given the following table

I get something like this

I then apply a formula like this formatDateTime(addDays('1899-12-30',int(DATE)),'dd/MM/yy') to get it as a Date type.

However, I've started to receive today this info as follow

Therefore the formula above is not working and impacting most of our flows.

Hopefully I'm doing something wrong instead of a change on how the Excel Connector is providing the info (it would have a massive impact!).

Can anyone point me in the right direction?

Many thanks

All responses (1)

Answers (0)

jinivthakkar 4,177 on 15 Jan 2021 at 06:21:12

Like (0)

Report
Re: Excel Connector dates extract issue (Change from integer to dates?)

try formatting the date as below :

formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd')