Need to get the days different between excel date and current date

(1) Share

Report

Posted on by AA-10091612-0

Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '45605.0555555556' was not valid. The datetime string must match ISO 8601 format.'.

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 53,690 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi,

It looks like you are getting back a String value of that Date in Ticks and thats the issue.

You need to convert it, firstly to a number (get rid of the .0555 garabage), and then turn those Ticks into a DateTime.

That's why its not working

Also when you do this, you need to make sure that you have a DateTime for both in the same format or use FormateDateTime in the flow to make them the same.

To convert from that to a number do int(yourstringhere)

Then do this to convert that into a DateTime

addSeconds('0001-01-01',div(YourTicksValue),10000000))

Then use dateDifference

or you can also follow this, it's simply a pivot on the above but works nicely

How to calculate the difference between two dates in Power Automate - Manuel T. Gomes (manueltgomes.com)

Was this reply helpful? Yes No