Hello, I have a query where I have the following criteria in a date column:
>=#01/04/2010# And <=#31/03/2011#
So, in effect, I want to bring forward all records where this date is between 1st April 2010 and 31st March 2011
HOWEVER,
My query is bringing back records with dates such as:
29/04/2011
15/03/2012
06/05/2012
I've checked that the format for this filed is in short date format.
Anyone have any ideas why these records are appearing when they should not?
Many thanks, S
>=#01/04/2010# And <=#31/03/2011#
So, in effect, I want to bring forward all records where this date is between 1st April 2010 and 31st March 2011
HOWEVER,
My query is bringing back records with dates such as:
29/04/2011
15/03/2012
06/05/2012
I've checked that the format for this filed is in short date format.
Anyone have any ideas why these records are appearing when they should not?
Many thanks, S