Excel date into ms flow

[Gopishrine]

Hi,

The below function worked perfectly but a few days back it stopped working. Any ideas why it stopped?

addDays('1899-12-30',int(item()?['RECD DATE']),'dd-MMM-yy')

[RezaDorrani]

Hi @Gopishrine ,

Now dates in excel are rendered as dates within flow. No need to do the number conversion logic.

https://twitter.com/rezadorrani/status/1349949409904250880?s=20

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[Gopishrine]

Hi,

But still, it's not working for me.

In the run history, it shows like below.

    "RECD DATE": "43685"

[RezaDorrani · Accepted solution]

Hi @Gopishrine,

Dates in excel will now once again be produced in serial number format. Microsoft has rolled back the change.

So go back to your original expression.

https://us.flow.microsoft.com/en-us/support/

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter