Date #26/10/2015# in query returns nothing

[Kobus-Dippenaar]

Good day to all,

I need some help about using dates, I don't understand why it is not working.

I have a date field defined as Date/Time format short date default value now() in the table.

Now running a query with criteria #26/10/2015# or now() return no records.
Could it be the time embedded in the date? or being part of the date?

I have even tried to compare the dates as per attached png picture.

Your assistance is welcomed.

Kobus

 

[Brianwarnock]

The use of NOW() will include a Time , you should have used Date()

lookup Datevalue function

Brian

 

[Brianwarnock]

On second thoughts just try Int(your field) as dates are a stored as a Double with before the decimal point being the year and after the time.

Brian

 

[arnelgp]

have you tried the format function

Where CMLDate = #" & Format(Date, "mm\/dd\/yyyy") & "#"

or

Where wsd = #" & Format(Date, "mm\/dd\/yyyy") & "#"

 

[Kobus-Dippenaar]

Thank you, I be reporting back soonest.
Blessings.