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.
Solved! Go to Solution.