Unanswered

Condition to compare dates in sharepoint

(1) Share

Report

Posted on by 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

Categories:

General topics

All responses (4)

Answers (0)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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 28 on at

Like
a
(0)

Report
Copy link

Link copied!

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

how do I change it to a logical function?
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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 28 on at

Like
a
(0)

Report
Copy link

Link copied!

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