Have you 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 of the video and the code snippets are below.
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'), '.')