Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #9004

Re: time check

Show all headers | View raw

Bob Quintal expressed precisely :
> bobh <vulcaned@yahoo.com> wrote in
> news:90186cc8-291b-48de-9c4e-d6be8740077c@googlegroups.com: 
>
>> Hi All,
>> 
>> I must be tired cause I can't figure out the vba to determine if
>> the current time is greater then 7pm 
>> 
>> If Time() > 7pm Then  <-- is what I'm trying to get to
>> 
>> help and thanks
>> bobh.
>> 
> if datepart("n",time()) >19
>
> or, better
>
> if datepart("n",now()) >19 Then

Shouldb't that be:
Datepart("H", Now())

Rdub

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

time check bobh <vulcaned@yahoo.com> - 2014-02-12 11:08 -0800
  Re: time check Bob Quintal <rquintal@sPAmpatico.ca> - 2014-02-12 21:27 +0000
    Re: time check Ron Weiner <rw@domain.com> - 2014-02-12 16:40 -0500
      Re: time check Bob Quintal <rquintal@sPAmpatico.ca> - 2014-02-12 23:45 +0000
  Re: time check "Access Developer" <accdevel@gmail.com> - 2014-02-12 13:55 -0600

csiph-web