DateTime difference in minutes

mr.burns

Hi all,

I have two DateTime variables and now I want to get the difference in minutes, and have to check if it is e.g. bigger that 10 minutes.

if I use message(format(dt2) - format(dt1)) it shows:

22 Minutes 34 seconds 884 milliseconds

But this value I cannot compare against 10 minutes, because it is text.

How can I get just 22 as integer result?

Thanks!

reijermolenaar

Hi mr.burns,

Try this:

ROUND((dt2 - dt1) / 1000 / 60, 1, '<');

Regards,

mr.burns

Hi,

thanks that helped!