Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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