Answered

Getting incorrect output from excel date

(0) Share

Report

Posted on by Nicktrom55

I have a flow where an email is generated at the end of the flow. I am using dynamic content from excel. when using it in the email for a date. it is giving me the output of 45226 vs 10/27/2023 which is the date value in excel.

How can i fix this?

I have the same question (0)

All responses (3)

Answers (1)

Ellis Karim 11,473 Super User 2025 Season 2 on at

Like (0)

Report

Re: Getting incorrect output from excel date

Hi @Nicktrom55 ,

Please try setting the DateTime format to ISO 8601 as shown:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Nicktrom55 65 on at

Like (0)

Report

Re: Getting incorrect output from excel date

It gave me this 2023-10-27T00:00:00.000Z

is there a way to get it to be 10/27/2023

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,473 Super User 2025 Season 2 on at

Like (0)

Report
Re: Getting incorrect output from excel date

Hi @Nicktrom55 ,

You can use an expression to format the date:

formatDateTime('2023-10-27T00:00:00.000Z', 'MM/dd/yyyy')

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No