Condition not working properly in date

[Boynogs123]

Hi Everyone,

When comparing the 01/07/2022 is greater than 10/01/2021 the answer is false. It is supposed to be true.

Why is the answer is false?  Here's the output below.

Thank you in advance!

[rubin_boer · Accepted solution]

hi @Boynogs123  it is two string you compare, and both are of the same length hence the false

try  comparing

ticks(formatDateTime(variables('varDateOne'),'M/d/yyy'))

ticks(formatDateTime(variables('varDateTwo'),'M/d/yyy'))

Result (true)

changing varDdateOne

Hope it helps

[Boynogs123]

Thank you @rubin_boer !