records with current date do not show in query

[impcmd]

In my query I want records that have todays date or greater to show. So in
the criteria field i have >=Date$(). I do not get todays date with this
expression I do get future dates. Not sure what I am doing wrong.

 

[pietlinden]

In my query I want records that have todays date or greater to show.  So in
the criteria field i have  >=Date$().  I do not get todays date with this
expression I do get future dates.  Not sure what I am doing wrong.

 

[Lord Kelvan]

not sure either it works for me you could always try >=date$()-1

regards
Kelvan

 

[impcmd]

When I do not have the $ I get no records I have my date format as MM/DD/YY.
Is that why?

 

[impcmd]

not sure either it works for me you could always try >=date$()-1

regards
Kelvan

Had to change the field format in the table

 

[John W. Vinson]

In my query I want records that have todays date or greater to show. So in
the criteria field i have >=Date$(). I do not get todays date with this
expression I do get future dates. Not sure what I am doing wrong.

Is this a Text field, or a Date/Time field? The Date$() function does not
return a date, it returns a text string. The text string "9/2/2008" is in fact
greater than the text string "10/15/2008"; could that be the cause?