Unanswered

Parsed date from excel appears as a serial number

(0) Share

Report

Posted on by EnochMan

When I parse a date from excel and try to use it as a dynamic content, it appears as a serial number.
I am looking for a way to make the date appear as a date format.

I am unable to apply formatdatetime to the dynamic content of the parsed date.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @EnochMan ,

Please take a look at this post.

https://powerusers.microsoft.com/t5/Building-Flows/Convert-serial-number-to-date-format/td-p/895975

Best Regards,

Wearsky

Was this reply helpful? Yes No
EnochMan 21 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot. I believe that should work, unfortunately making that change will affect the rest of my flow.
My flow sends an email reminder 2 weeks before a date in an excel file expires.
To do that, I have had to convert today's date into a serial number and compare it with the date in the excel sheet.
Then I use the list rows present, filter array (to compare the two integers, i.e todays date and the date of expiration) and parse Json to make the contents of the excel sheet available.
If I change the date format in the excel connector to ISO 8601 my flow fails because the filter array cannot compare it as an integer with today's date (which I have converted to an integer).
I want to find a way to maintain the flow and change the parsed date which is an integer into the ISO 8601 format.
Thanks a lot.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @EnochMan ,

Please try this

Best Regards,

Wearsky

Was this reply helpful? Yes No