Data Miss Match on report

[ahmed_optom]

Hi Everyone,

I have a simple report, one of the columns is a date. The report works fine, but if I right click the date and try to filter for example for today, it behaves in a weird way. It either comes up with a data miss match error in criteria expression, or just shows me some of the filtered records for that day.

Its as if the datatype is wrong, but i checked the table and it is a date/time.

It does seems to work correctly if i use the "between" filter, except for today, when i try to use that trick for today, it doesnt show me any records.

 

[JHB]

..
It does seems to work correctly if i use the "between" filter, except for today, when i try to use that trick for today, it doesnt show me any records.

It sound like your date is both day and time, if yes then use the format function to get only the date.

 

[Ranman256]

yeah, if time gets into the mix, it effects the BETWEEN.