Share
ReportHi,
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')
You’re offline. This is a read only version of the page.
20
Hi,
The below function worked perfectly but a few days back it stopped working. Any ideas why it stopped?
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
Hi,
But still, it's not working for me.
In the run history, it shows like below.
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
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
All responses (
Answers (
