You’re offline. This is a read only version of the page.
I have date column in excel like this:
I'm sending same table to outlook email but date column data is changing to 44096. Please assist
Hi!
44096? The number you got is due to the fact the Excel column is formatted as Date, right?
It represents nr of days since 1899-12-30; it's the internal format used by Excel.
So either you switch the Excel column format into text, and apply @CFernandes suggestion or, keep it as date format, and once in your Flow, transform into ISO 8601 date format, wich is the internal one handled by Power Automate. Wanna keep the date format? Then you can use the following WDL expression:
Share
Report
All responses (
Answers (
addDays('1899–12–30T00:00:00Z',int(item()?['TestingDate']))
Just replace item()?['TestingDate'] and use instead the dynamic content element representing your Date column.
Please note addDays() offers optionally the possibility to customize ISO 8601, in a similar way as formatDateTime() does. I haven't customized the output in my example.
For more info, please have a look to this excellent article:
https://www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate
Hope this helps
@Anonymous
Hey Mate,
Can you try using the formatdatetime() function.
formatDateTime('9/22','dd-MM-yyyy')
You can find more details at https://sharepains.com/2018/11/12/formatdatetime-flow-power-automate/
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
