Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Date Comparision rounding

Tom Lapkowicz
Tera Expert

Hello.  I have a workflow in Flow Designer that is doing a comparison between a Date and a DateTime value but I can't get it to "round up" like I want to.

 

For example:

Starting Date = 11-10-2023 00:00:00 (DateTime value - this value will always have 00:00:00 as the time)

Ending Date = 11-11-2023 (Date value)

 

I would expect/need that the Date Comparision return a value of 1 in this situation but it returns a value of 0 (full list of Date Comparision results below). 

 

Any ideas on how I would get it to return a value of 1?  Thank you.

 

Full Date Comparision:

Difference days = 0.0

Difference hours = 19

Difference minutes = 1140

Difference months = 0

Difference weeks = 0

Difference years = 0

 

0 REPLIES 0