How are you putting the date in? Dates are stored as numbers, and a number
of 0 corresponds to 30 Dec, 1899, so it sounds as though you're not actually
getting a valid value in the date field.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Rowlie" <rowlie.man@btinernet.com> wrote in message
news:cat50v$cqk$1@titan.btinternet.com...[color=blue]
> Hi
> I am very new to access. I am starting a new job and have been asked to
> design a data base.
> After much messing around I have got something that is just o.k.
> The problem is that every time I put a date in it displays 1899, never the
> right date.
> I have tried short date long date every sort of date. But it will not
> display the current date.
> The system date is fine.
> Hope you can help thanks Andrew
>
>[/color]
