Get the Number of Days Between Two Dates | Power Automate

Ever wanted to calculate the days or days and time between two dates on Power Automate? Then watch just how easy it is, once you understand the logic, with this video tutorial. I will walk you through step-by-step instructions explaining the complexity and the benefits and negatives of both methods.
As mentioned above, I go through a comparison of older and newer methods, ensuring you can make the best decision for what is right for you. So let me know if you have any questions in the comments below and you can find all of the code below this paragraph.
Ticks Method:
div(sub(ticks(outputs('Compose_-_End_Date')),ticks(outputs('Compose_-_Start_Date'))),864000000000)
dateDifference() Method:
dateDifference(parseDateTime(outputs('Compose_-_Start_Date'), 'en-ca'), parseDateTime(outputs('Compose_-_End_Date'), 'en-ca'))
Splitting the Date Difference Method:
split(outputs('Compose_-_dateDifference_Function'), '.')
#powerautomate #powerplatform #dataverse

[@franknielsen3219]

Very cool 😊😊

[@gbu03]

If we select the date time in list rows action is iso format then the column of all the date should be changed into iso 8601 format but if 1 column doesn't convert into 8601 format then what could be the reason? Thanks

[@FlowJoeVideos]

Have you checked that the column that isn’t changing is actually a date time format and not a string (text) format?