Calculate the number of days between today and created

[efebo]

Hi,

I need help, please.

I need to run a daily workflow to get files that met the following conditions: Status is pending AND was created 2 days ago or more.

I was able to complete the status part but I couldn't figure out the date part. I tried to use the ticks function and I failed.

Thanks in advance. 

[PrasadAthalye]

@efebo - You can add a calculated field in SharePoint list with formula as Today()-Created. Then Use that field in the flow.

Like and Mark this as answer if this resolves your issue.

[Diksha · Accepted solution]

Hello @efebo ,

You can use the following filter query - 

Status eq 'Pending' AND Created le '@{formatDateTime(addDays(utcNow(), -2), 'yyyy-MM-dd')}'

Try this out !!!

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Thank You !!!

[efebo]

Thanks, both for answering.