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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking to SQL Server db table 6
Parameters in queries 13
Autofill Date in Word 15.33 for Mac 0
converting dates from file 3
Incorporating the User Profile location into a document template path 1
Date format/value different when opening manually compare to VBA macro 4
Setting a default zoom in Infopath 0
Display weeks from a Milestone 0

Top