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???
Solved! Go to 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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @ElaK ,
Try converting it to ticks(100 nanoseconds interval):
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog@abm Thank you, your solution worked!
I never worked with ticks, and trying to avoid.