Simple Compare Date - Can't find solution

[drummer]

My flow is simple.  Trying to compare project start date with time now and if project start date is earlier (eg. less) than today  then Yes. This flow runs but no matter what I try I cannot get a yes so I am assuming either I've editing this too many times and it's corrupt (is that possible or how to tell) or I'm missing some secret answer to how one component works that I'm not getting value to compare.

I've tried yyyy-MM-dd format with and without timestamp. I've converted the dates to ticks and divided out to get days for smaller numbers but can't get the condition to give me a yes.  What is wrong? with date formats to make a simple condition not work with power automate comparing dates. 

1. Dataverse when the project start date field is modified

2. Converted both dates to format

3. Create ticks (since I couldn't get the yyyy-MM-dd to compare (I've tried just day and then with longer date format as is here) as I've seen so now moved to ticks - I can confirm the ticks calculate a number is shown 

4. Is less than condition (just with some limitation of a test record as I test)

What am I missing? Any expert help is appreciated.

[abm · Accepted solution]

Hi @drummer 

Thanks for the screenshare. The issue was not related to date. The issue was related to status code text value which you are comparing. 

Thanks

[drummer]

Yes exactly I was comparing a value "new" but not using right field for name so it was comparing 1 to "New" vs . New to new. ty super helpful