If Bigger Date

[Sababneh]

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:

The template validation failed: 'The template action 'Condition' at line '1' and column '1604' is not valid: "Unable to parse template language expression 'greater(formatDateTimeitems('Apply_to_each')?['OData__PipeExpectedVisitDate'],'yyyy-MM-dd'), formatDateTime(items('Apply_to_each')?['OData__PipeDealVisitedDate'],'yyyy-MM-dd'))': expected token 'EndOfData' and actual 'Comma'.".'.

Help please

[v-yuazh-msft · Accepted 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

[Sababneh]

Thank you @v-yuazh-msft

It worked just fine 🙂

Btw the columns were Date Type.

Thank you again.