Dates defaulting to 2008

T

TommoUK

I have a form in Access 2007 that has 2 combo boxes that select dates from a
single table (FROM and TO). The table that I am using for test purposes has
dates from Apr-07 to Nov-07.

Prior to New Year (i.e. 2007), if I clicked one of the combo boxes, it
showed Apr-07 to Nov-07. If, for example, I clicked on Nov-07, Nov-07 would
appear in the box. Everything normal!

However, since the turn of the year (i.e. 2008), if I do the same thing
(select Nov-07), Nov-08 appears in the box ... even though Nov-08 does not
exist in the source table.

Does anyone know a way around this problem?

Many thanks in advance.
 
R

Rick Brandt

TommoUK said:
I have a form in Access 2007 that has 2 combo boxes that select dates from a
single table (FROM and TO). The table that I am using for test purposes has
dates from Apr-07 to Nov-07.

Prior to New Year (i.e. 2007), if I clicked one of the combo boxes, it
showed Apr-07 to Nov-07. If, for example, I clicked on Nov-07, Nov-07 would
appear in the box. Everything normal!

However, since the turn of the year (i.e. 2008), if I do the same thing
(select Nov-07), Nov-08 appears in the box ... even though Nov-08 does not
exist in the source table.

Does anyone know a way around this problem?

Many thanks in advance.
Click to expand...

Access is interpreting the number as the day and when provided with only a month
and day it always assumes you want the current year. Either provide all three
parts of the date or use a four digit year.
 
Top