condition if an action is late is returning false result, but should be true

[ElaK]

I have this condition in my flow. Up until now, it worked correctly. It even worked correctly an hour ago, and then it didn't. I am running out of ideas what could have gone wrong and why it is returning false result

Condition compares these 2 dates:

Output 1)

Output 2)

If Output 1) is less than Output 2), then condition should be "true"- meaning- YES, the submission is late

In this case Output1) 11/27/20, and Output2) 1/4/21, so 11/27/20<1/4/21, hence the condition is TRUE, but the result comes back as FALSE.

Do you have ANY IDEA why???

[sakula1996]

Hi @ElaK ,

Try converting it to ticks(100 nanoseconds interval):

ticks(formatDateTime('11/27/20', 'MM-dd-yyyy'))

ticks(formatDateTime('10/27/21', 'MM-dd-yyyy')) 

Thanks

[abm · Accepted solution]

Hi @ElaK 

You can compare the dates always using yyyyMMdd format and returned as an integer.

Try using

formatDateTime('yourdate', 'yyyyMMdd') 

So in your case 11/27/20<1/4/21

11/27/20 will return as 20201127 integer

1/4/21 will return as 20210401 integer

So always 2021127 < 20210401

[ElaK]

@abm Thank you, your solution worked!

I never worked with ticks, and trying to avoid.