Hi.
I'm sorry to bother you with a problem which may be an easy case...
In a standard table, one of the fields have the Data Type: Date/Time, with format ShortDate.
But, when I filter on the field in the table and select a specific date available in the filtering list, I just get one row with the selected date. Even there is several rows with the selected date. And, it's not showing the first or last row, it shows one 'in the middle (among around 50 rows with this date).
I'm aware of issues around different date format depending on location. So when I create a query on the table an set the filter on the same specific date, I get 0 records. When entering #01/10/2024#, ms access will automatic translate/change it to #01.10.2024#. The actual date is 1st of October, but I have also tried #10.01.2024# with no luck.
Then, in the query I changed the criteria to >= #01.10.2024# And <#02.10.2024# and now it gives me the wanted result. But how come? What am I doing wrong since the criteria on the single date won't work? Is the 'time-part' of the field who is making this issue - despite the fact that the format is ShortDate?
Best Regards,
Geirr.
I'm sorry to bother you with a problem which may be an easy case...
In a standard table, one of the fields have the Data Type: Date/Time, with format ShortDate.
But, when I filter on the field in the table and select a specific date available in the filtering list, I just get one row with the selected date. Even there is several rows with the selected date. And, it's not showing the first or last row, it shows one 'in the middle (among around 50 rows with this date).
I'm aware of issues around different date format depending on location. So when I create a query on the table an set the filter on the same specific date, I get 0 records. When entering #01/10/2024#, ms access will automatic translate/change it to #01.10.2024#. The actual date is 1st of October, but I have also tried #10.01.2024# with no luck.
Then, in the query I changed the criteria to >= #01.10.2024# And <#02.10.2024# and now it gives me the wanted result. But how come? What am I doing wrong since the criteria on the single date won't work? Is the 'time-part' of the field who is making this issue - despite the fact that the format is ShortDate?
Best Regards,
Geirr.