Query does not pull up data for date 12/08/2014...I am totally lost; please help.

[Alphix]

Query does not pull up data for date 12/08/2014...I am totally lost to why not; please help.





Please see attachment.

Test Query 2.zip


Thanks a bunch.

[pbaldy]

The date values in the table have a time component, hidden by the format of the field.

[Alphix]

Thanks...I totally forgot about that.

[pbaldy]

No problemo.

[Alphix]

How can I have a date entered into a variable without the time component.

I have tried using Date()...But once I go to the other line the parenthesis disappear?

Also Now() function has a time component.

I am not sure how to have just a straight date entered.

Please Advise.

[pbaldy]

You can use Date(). Sometimes it will drop the parentheses, but it should still work. If you have a field named Date and need to disambiguate, use VBA.Date in code.