Dates defaulting to 2008

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TommoUK - 21 Jan 2008 04:01 GMT

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.

Reply to this Message

Rick Brandt - 21 Jan 2008 04:07 GMT

>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
[quoted text clipped - 11 lines]
>
> Many thanks in advance.

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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

TommoUK - 21 Jan 2008 04:34 GMT

Thanks for the speedy response Rick.

Everything working now.

> >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
[quoted text clipped - 15 lines]
> and day it always assumes you want the current year. Either provide all three
> parts of the date or use a four digit year.

Reply to this Message