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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
12 | |
11 | |
7 | |
7 | |
6 |
User | Count |
---|---|
18 | |
17 | |
12 | |
10 | |
9 |