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