Filter by Date

P

Pete

When the date filter is applied in a Form not every row with the same date is
being filtered. I suspect this is due to a hidden time factor. How do you
format the cell so that all records in a column with the same date will be
filtered out when required?
 
S

strive4peace

Hi Pete,

not format... strip the time away -- one way is to use the DateValue
function

me.filter = "DateValue([DateFieldName]) = #" & me.somedate & "#"
me.filteron = true

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top