Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

select records in access table where date is equal to specific date

I have an Access database that has a datetime field in it. I need to read records from my tblOrder table and only select records where the date is equal to today.

How would I code something like this? I am using the SQL statement in my ASP script.

Thanks in advance.
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
select * from yourtable where datefield >= date() and datefield < dateadd("h", 24, date())

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now