Answered

If Bigger Date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

General topics

All responses (2)

Answers (1)

Sort by

Verified answer

v-yuazh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-yuazh-msft

It worked just fine 🙂

Btw the columns were Date Type.

Thank you again.