Condition to compare dates in sharepoint

[rory99]

Hi All

I am trying to create a flow that is coping items from one SharePoint to another by comparing today's date to the date of the item and if matches it copied the entire item to a different list

Comparing 

this is my condition: 

formatDateTime(triggerBody()?['Start_x0020_Date_x0020_At_x0020_'],'yyyy-MM-dd')  is equals to formatDateTime(utcNow(),'yyyy-MM-dd')

It does not seem to work this way...anyone have a better understanding of how to accomplish that?

Please help

[ScottShearer]

@rory99 :

You probably want to use the equals expression which you'll find under logical functions:

equals(formatDateTime(triggerBody()?['Start_x0020_Date_x0020_At_x0020_'],'yyyy-MM-dd'),formatDateTime(utcNow(),'yyyy-MM-dd'))

If this addresses your issue, please mark your post as Solved.

Scott

[rory99]

Maybe I'm missing something here...my condition looks like this:

how do I change it to a logical function?

[ScottShearer]

@rory99 

I did not realize that you had this is a condition as there was no screen shot.

I don't see anything wrong with your logic or formatting.

When you say it doesn't work, are you saying that is never true or are you saying that it errors out?

One suggestion that I have:

Create two string variables.  Set the values of each string variable to the results of one of your formatDateTime expressions.  Run the Flow and view the results in the history.  Do the values in the variables appear to be the same?

Scott

[rory99]

Hi Scott

It does not work since the condition result is always false

I actually tried to create two differetn strings and did see that they indeed match for some of the items