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

(0) Share

Report

Posted on 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

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!
try formatting the date as below :

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

Was this reply helpful? Yes No