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
S
try formatting the date as below :
formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd')