Question

Comparing Time in Mendix

1

Hello, I have two date time variables → current date time and day end time. I just want to compare time of these two variables not the date. How can I do so.

asked 2022-10-19

Saryu Chugh

1 answers

Eline Bijkerk · Answer 1 · 2022-10-19

What you want to do is take the time of each of these dates and put them on the same date.

So for instance:

minutesBetween

(

parseDateTime('01-01-2020 ' + formatDateTime($Date1, ‘HH:mm:ss’), 'dd-MM-yyyy HH:mm:ss'),

parseDateTime('01-01-2020 ' + formatDateTime($Date2, ‘HH:mm:ss’), 'dd-MM-yyyy HH:mm:ss')

)