[AccessD] Check date-time problem

Stuart McLachlan stuart at lexacorp.com.pg
Fri Jul 1 01:51:22 CDT 2005


On 30 Jun 2005 at 22:38, Sad Der wrote:

> Example:
> 
> current time=21:37
> StartPauzeAt=21:00
> EndPauzeAt=3:00
> 

Is StartPauzeAt  always later than EndPauzeAt?  If not you need two 
different conditions.

If StartPauzeAt > EndPauseAt then  'wraps at midnight
   If currenttime > StartPauzeAt or currenttime < EndPauzeAt then
      .....  'Pauze
   end If
Else   ' all in the same day
  If current currenttime > StartPauzeAt and currenttime < EndPauzeAt then
     .... 'Pause
  End If
End If



-- 
Stuart





More information about the AccessD mailing list