dates

  • Thread starter Thread starter colmkav
  • Start date Start date
C

colmkav

Hi,

how can I write an SQL query to test whether the date is today? Ie
what is the function I need to use?

eg select * from mytbl where fldDATE = now()

but obviously now isnt the correct function.

Colm
 
The Now function returns the current date and time.

The Date function returns the current date only.

The Time function returns the current time only.
 
The Now function returns the current date and time.

The Date function returns the current date only.

The Time function returns the current time only.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)










- Show quoted text -
Click to expand...

thanks.
 
Back
Top