In access qurey by date?

0 ⤊

In access qurey by date?

Hello

In Access how do you qurey by a date. normally I would put "Date()" but the date format also includes the time so its not pulling correctly. I want it to ignore the time and only pull records with todays date????

Thanks

2007-02-01 04:25:57 · 3 answers · asked by relms2000 1 in Computers & Internet ➔ Programming & Design

3 answers

check out the formatting functions - they can return a part of the date (exclude the time if you want).

2007-02-01 08:43:10 · answer #1 · answered by Richard H 7 · 0⤊ 0⤋

I have the same problemw ith my system and found that using >(use yesterdays date in mm/dd/yyyy format) works...

2007-02-01 04:45:49 · answer #2 · answered by Paul 2 · 0⤊ 0⤋

Try CDate(Format(Now(), "Short Date"))

2007-02-01 04:29:16 · answer #3 · answered by Cory P 2 · 0⤊ 0⤋