VB - Simple Time Formula (for some!!)

am 20.11.2007 14:44:22 von mattcolenutt

Hi, I'm after what seems to be a simple formula.

For example:

If Now() >= 10am then
do this
else
do that

endif

Thanks very much.

Matt

Re: VB - Simple Time Formula (for some!!)

am 20.11.2007 14:52:38 von lyle

On Nov 20, 8:44 am, Lynx101 wrote:
> Hi, I'm after what seems to be a simple formula.
>
> For example:
>
> If Now() >= 10am then
> do this
> else
> do that
>
> endif
>
> Thanks very much.
>
> Matt

Hour(Now()) >= 10

Re: VB - Simple Time Formula (for some!!)

am 20.11.2007 15:06:25 von Tom van Stiphout

On Tue, 20 Nov 2007 05:44:22 -0800 (PST), Lynx101
wrote:

Check out the DateDiff function.
-Tom.

>Hi, I'm after what seems to be a simple formula.
>
>For example:
>
>If Now() >= 10am then
> do this
>else
> do that
>
>endif
>
>
>Thanks very much.
>
>Matt