Date format converting to numbers

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
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:

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

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

So, you finally transformed your Excel date column format from date to text, right?

Good Job and... happy flowing!

Was this reply helpful? Yes No