Date field is within 1 month of current date

[Delpierita]

I have a condition where I check if a date field is between (Today-30 days) and (Today).

Hello,

I have the below conditions:

- formatDateTime(item()?['Negotiation_x0020_date'],'dd/MM/yyyy') is greater than or equal to 

formatDateTime(item()?['Today_x0020__x002d__x0020_30_x00'],'dd/MM/yyyy')

- formatDateTime(item()?['Negotiation_x0020_date'],'dd/MM/yyyy') is less than or equal to 

formatDateTime(item()?['Today'],'dd/MM/yyyy')

I have an item which meets these conditions, but the result is false.

I can't figure it out what am I doing wrong.

Thank you,

Paula

 

[v-yamao-msft · Accepted solution]

Hi @Delpierita ，

What’s the column type of “Today_x0020__x002d__x0020_30_x00”? I assume that it is a calculated column in the list.

For your scenario, if you would like to check if a date field is between Today-30 days and Today, please try to use adddays function instead of using a calculated date from the list.

The functions in the Condition are:

formatDateTime(items('Apply_to_each')?['Date'],'yyyy-MM-dd')

is greater than or equal to

formatDateTime(addDays(utcNow(),-30),'yyyy-MM-dd')

And

formatDateTime(items('Apply_to_each')?['Date'],'dd/MM/yyyy')

is less than or equal to

formatDateTime(utcNow(),'yyyy-MM-dd')

A screen shot for the flow:

Best regards,

Mabel

[Willemijn]

Hi, 

I think you're equation should be something like:

formatDateTime(triggerBody()?['Negotiaton_x0020_date'],'dd-MM-yyyy') is greater or equal to 

formatDateTime(addDays(utcNow(),-30),'dd-MM-yyyy')

and 

formatDateTime(triggerBody()?['Negotiaton_x0020_date'],'dd-MM-yyyy') is less or equal to formatDateTime(utcNow(),'dd-MM-yyyy')

utcnow() is the 'today' in Flow, and with addDays() you can add or substract days from you're chosen date. 

Hope this helps