How to compare military time and doay of the week?

[rkckjk]

How would I check to see if the current time(military format) is
greater then 07:30AM and the day of the week is Monday-Friday.

Pseudo code:

If Current_Time > 07:30AM and Current_Day = Monday or Current_Day =
Tuesday _
or Current_Day = Wednesday or Current_Day = Thursday or Current_Day =
Friday
then
Do this
else
Do something else
end if

 

[Horowitz]

        If TimeOfDay > #7:30:00 AM# And Not (Now.Day = 5 Or Now.Day = 6) Then
            'code for day Monday to Friday
        Else
            'code for time > 7:30:00 AM OR day = Saturday or Sunday 
        End If

To understand what I do write "day." and select a day watching the tooltexttip that appears. Each day has a number...


Ok ???

 

[ThatRickGuy]

now.day will return the day of the month.

try something like this:

if now.dayofweek <> dayofweek.saturday and _
   now.dayofweek <> dayofweek.sunday and _
   now > #7:30:00 AM# Then
  'your code
end if

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[Horowitz]

I do not agree with "now.day will return the day of the month

 

[ThatRickGuy]

Check the documentation.

now.date returns todays date,
now.month returns the current month,
now.year returns the currenct year,
now.day returns the currect day of the month (ie: 1-31)
now.dayofweek returns the day of the week (ie: 1-7)

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.