Unanswered

AddDays utcNow date format

(0) Share

Report

Posted on by SPRock76

I need help to formulate Filter Query. I have a flow with (sharePoint) Get Items action with Filter Query. What I am trying to to is to get all changes in the list for last 2 days. This formula that I used in the Filter Query seems to work but not the format I want.

This is the formula I used in the Filter Query -

Created ge 'addDays(utcNow('MM-dd-yyyy'),-2,'MM-dd-yyyy')' and Modified ge 'addDays(utcNow('MM-dd-yyyy'),-2,'MM-dd-yyyy')'

This is the date format from the flow -

2020-10-15T14:42:11Z

My desired date format -

10-15-2020 or 10/15/2020. I want the date to be displayed as MM DD YYYY.

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

fchopo 8,003 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hello @SPRock76

In the filter query expression you should use the format 'YYYY-MM-DDThh:mm:ssZ', so the expression you would be:

Created ge 'addDays(utcNow('YYYY-MM-dd'),-2)' and Modified ge 'addDays(utcNow('YYYY-MM-dd'),-2)

If you want to change how the date is displayed, then you should apply the desired format using an expression like:

formatDateTime('your_datetime_variable','MM-dd-YYYY')

Hope it helps!

Ferran

Was this reply helpful? Yes No
ajdhingr Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@SPRock76 - Please let us know if the issue is resolved. To understand more abt date and time you may also refer to this https://flowaltdelete.ca/2020/10/15/converting-time-zones-easily-in-power-automate/ blog also.

@fchopo thanks for sharing the solution

Was this reply helpful? Yes No
emersonbruce 54 on at

Like (0)

Report
Copy link

Link copied!

you should use the Add dynamic content > Expression tab > enter text as noted below adjusted to your needs > ok
the format uses a lower case y
addDays(utcNow('yyyy-MM-dd'),-2)
I adjusted the 2 to 30 days for 30 day old incomplete task emails to be sent daily.

Was this reply helpful? Yes No