ahmed_optom
Registered User.
- Local time
- Today, 17:14
- Joined
- Oct 27, 2016
- Messages
- 93
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.
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.