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
User | Count |
---|---|
36 | |
21 | |
19 | |
14 | |
11 |
User | Count |
---|---|
26 | |
20 | |
20 | |
14 | |
13 |