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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
34 | |
15 | |
15 | |
13 | |
8 |
User | Count |
---|---|
40 | |
32 | |
25 | |
13 | |
12 |