Hey all,
I'm using Microsoft Flows, and I want to know if the date 1 is bigger than date 2, but it is not working:
@greater(formatDateTimeitems('Apply_to_each')?['OData__PipeExpectedVisitDate'],'yyyy-MM-dd'), formatDateTime(items('Apply_to_each')?['OData__PipeDealVisitedDate'],'yyyy-MM-dd'))
it gives me this error:
Solved! Go to Solution.
Hi @ Sababneh,
Could you please share more details about the error?
What is the type of the “OData__PipeExpectedVisitDate” column and “OData__PipeDealVisitedDate” column?
I found that your expression is missing a parenthesis “(” , you could add a “(” in your expression as below:
@greater(formatDateTime(items('Apply_to_each')?['OData__PipeExpectedVisitDate'],'yyyy-MM-dd'), formatDateTime(items('Apply_to_each')?['OData__PipeDealVisitedDate'],'yyyy-MM-dd'))
Please check the expression that you used in your flow.
I have create a flow add use the expression above as screenshot below:
The flow would run successfully as below:
Regards,
Alice Zhang
Hi @ Sababneh,
Could you please share more details about the error?
What is the type of the “OData__PipeExpectedVisitDate” column and “OData__PipeDealVisitedDate” column?
I found that your expression is missing a parenthesis “(” , you could add a “(” in your expression as below:
@greater(formatDateTime(items('Apply_to_each')?['OData__PipeExpectedVisitDate'],'yyyy-MM-dd'), formatDateTime(items('Apply_to_each')?['OData__PipeDealVisitedDate'],'yyyy-MM-dd'))
Please check the expression that you used in your flow.
I have create a flow add use the expression above as screenshot below:
The flow would run successfully as below:
Regards,
Alice Zhang
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
46 | |
10 | |
9 | |
8 | |
7 |
User | Count |
---|---|
67 | |
22 | |
12 | |
11 | |
11 |