Problem compare two hours

HCL Domino Domino Forum
1

Here’s my problem, I have two field (StartHour and EndHour). I try to detect if StartHour <= midnight and if EndHour >= midnight. I can’t do this because my two field is only Hour. Do you have a solution in lotuscript

thanks

2

Subject: Problem compare two hours

How about

If Start Hour > End Hour then {duration spans midnight}.

Note : That will ONLY work if the duration between Start and End is always going to be less then 24 hours.

3

Subject: Problem compare two hours

IMHO if I understand you, the problem is not related to Lotusscript. The comparison that you are making is ambiguous. For example, if the hour (assuming 24 hour clock) is “03”, then it’s after the previous midnight, but before the next midnight. As it will always be. It depends on which midnight you’re talking about.

Without some form of date reference, the comparison would seem to be meaningless.