web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Need to get the days d...

Power Automate

Suggested Answer

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

(1) Share

Report

Report

Posted on by AA-10091612-0

2

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Michael E. Gernaey 53,960 Moderator 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

Join the conversation