Using DateDiff() in the compose action

[Anonymous]

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

[v-yamao-msft]

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

[ManjunathaReddy]

Could you please let me know how to get difference between two dates using microsoft flows. If any that would be appriciated.