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

Invalid Dates

P: n/a
I have a database setup in which one of the fields is a date. In most
cases, the exact date is known, however, there are a few instances
where only the month and year are known. Is there anyway to enter
partial dates into date fields?

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
No. Internally Access stores the date as a real number, where the integer
part represents the date, so there is no such thing as a month-and-year-only
date.

One option is to add a yes/no field field such as BirthDateIsAGuess.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Grant Nosbush" <gm******@yahoo.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
I have a database setup in which one of the fields is a date. In most
cases, the exact date is known, however, there are a few instances
where only the month and year are known. Is there anyway to enter
partial dates into date fields?

Nov 13 '05 #2

P: n/a
No. Internally Access stores the date as a real number, where the integer
part represents the date, so there is no such thing as a month-and-year-only
date.

One option is to add a yes/no field field such as BirthDateIsAGuess.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Grant Nosbush" <gm******@yahoo.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
I have a database setup in which one of the fields is a date. In most
cases, the exact date is known, however, there are a few instances
where only the month and year are known. Is there anyway to enter
partial dates into date fields?

Nov 13 '05 #3

P: n/a
That's what I thought. I guess another option would be to create three
separate integer fields, one for day, month, and year.
Allen Browne wrote:
No. Internally Access stores the date as a real number, where the integer
part represents the date, so there is no such thing as a month-and-year-only
date.

One option is to add a yes/no field field such as BirthDateIsAGuess.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Grant Nosbush" <gm******@yahoo.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
I have a database setup in which one of the fields is a date. In most
cases, the exact date is known, however, there are a few instances
where only the month and year are known. Is there anyway to enter
partial dates into date fields?


Nov 13 '05 #4

P: n/a
That's what I thought. I guess another option would be to create three
separate integer fields, one for day, month, and year.
Allen Browne wrote:
No. Internally Access stores the date as a real number, where the integer
part represents the date, so there is no such thing as a month-and-year-only
date.

One option is to add a yes/no field field such as BirthDateIsAGuess.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Grant Nosbush" <gm******@yahoo.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
I have a database setup in which one of the fields is a date. In most
cases, the exact date is known, however, there are a few instances
where only the month and year are known. Is there anyway to enter
partial dates into date fields?


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.