By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

New Be Need help with date.

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <ro********@btinernet.com> wrote in message
news:ca**********@titan.btinternet.com...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.