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.
 

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

Parameters in queries 13
linking to SQL Server db table 6
Posting a dataset to a SQL table using VBA 0
Selecting dates in SQL Server 6
Union query not showing all fields 4
Date format/value different when opening manually compare to VBA macro 4
converting dates from file 3
Page_Load question in ASPX 2

Back
Top