date filter

  • Thread starter Thread starter simcon
  • Start date Start date
S

simcon

my table has a date/time field. when I datasheet it , it shows date in format
dd/mm/yy. In my report I want to filter the date field on 8th Feb 2008.
If I set filter to tabdate = #08/02/2008# it doesn't find any records,
however if I put tabdate = #02/08/2008# it finds them fine.
Why do I have to use mm/dd/yyy format ?
 
simcon said:
my table has a date/time field. when I datasheet it , it shows date in format
dd/mm/yy. In my report I want to filter the date field on 8th Feb 2008.
If I set filter to tabdate = #08/02/2008# it doesn't find any records,
however if I put tabdate = #02/08/2008# it finds them fine.
Why do I have to use mm/dd/yyy format ?
Click to expand...
I live in the UK where we hold dates in DD/MM/YY format
 
Back
Top