Calculate the time between 2 days

0
I'm trying to capture the number of days between two dates and compare it to a decimal , however I keep getting an error.   Error: " com.mendix.webui.WebUIException: Exception while executing runtime operation    at com.mendix.webui.actions.client.RuntimeOperationAction.$anonfun$apply$1(RuntimeOperationAction.scala:54) Caused by: com.mendix.modules.microflowengine.MicroflowException: Failed to evaluate expression, error occurred on line 1, character 1daysBetween($CurrentDate,$IteratorSupplierListDetails/DateModified)<=$Decimal^     at ApprovedSupplierList.CreateUpdateReport.nested.abd64462-0e0e-4a71-9801-e2a546fe98a8 [1 of 899] (Gateway : 'Days Between')    at ApprovedSupplierList.CreateUpdateReport (ListLoop : '')"    Microflow:  
asked
4 answers
1

Nine out of ten times, this error occurs when one of the values you are trying to evaluate is empty. Did you debug your microflow?

answered
1

Looks like any arguments are missing in your compare, first try to print that value in log and check

what values are coming.

image.png

answered
1

One of the date attributes is null or empty

you can make a decision before the expression to avoid this error and make sure that the date attributes is not null

answered
0

Thanks everyone. The error was because of a null value.

answered