Hi ,
I am having a requirement to get the difference between 2 dates. I have formatted dates in the compose action & need to compare them.
DateDiff("5/22/2018","9/20/2017",days) is displaying as is in compose action and doenot calculate.
Looking for a suggestion.
Regards,
MB3
Hi MB3,
Per my certain knowledge, currently there is no direct date function can be used to calculate days difference between two dates.
If the two dates are within a month, we may consider to use a workaround by formatting the Date string, then convert the string into int, then get the date separately, then use sub function to calculate.
It would be convenient to have a function likes DateDiff to count days between two dates, please consider to submit a request at Flow ideas Forum, I will help collect and report it on my side.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Mabel Mao
Could you please let me know how to get difference between two dates using microsoft flows. If any that would be appriciated.