dates

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
 
D

Douglas J. Steele

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.
 
C

colmkav

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.
 
Top