Question

Calculating with MinutesBetween

2

What's wrong with this: round(minutesBetween($Meldingen/createdDate, [%CurrentDateTime%])) < 60

asked 2010-09-22

Jacco Feenstra

2 answers

3

Storing [%CurrentDateTime%] in a separate variable, for example $now, might solve the issue.

Update

Ok, the error occurs at runtime, not at designtime? In that case the error means that either $Meldingen/createDate or $Tijd = null.

answered 2010-09-22

Michel Weststrate

David Sanders · Accepted Answer · 2010-09-22

Try creating an integer variable and setting it to round(minutesBetween($Meldingen/createdDate, [%CurrentDateTime%])). Does this work? Use a message or breakpoint to examine the value returned. If all is OK, then manipulate the returned value using the mod function to convert to hours/mins