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?
4  2164 
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?
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?
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?
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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Craig Thomson |
last post by:
I'm using strtotime to validate a date/time passed in from a form but
am having some problems with it. It seems to allow invalid values,
such as "2004-04-13 21:66:13".
Does anyone know why this...
|
by: Krung Saengpole |
last post by:
Hi,
I used SQL Server 2000 Personal Edition. I created a stored procedure
having input parameters as smallint,tinyint,char,varchar and
smalldatetime. When I executed it by Query Analyzer, it's...
|
by: Ron Brennan |
last post by:
Good morning.
I would like to use one or more RegExps to validate country names as having
the first and last words beginning with an uppercase letter, intermediate
words beginning with either...
|
by: jayj0nes |
last post by:
I'm querying a Mas90 db via ADO in Access.
The following SQL gives me the error "Invalid Operand for Operator: ="
"SELECT * from GL_DetailPosting where PostingDate >= '#01/01/2004#'"
These other...
|
by: Grant Nosbush |
last post by:
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...
|
by: Mage |
last post by:
Hi,
can pgsql acceppt invalid date values? Sometimes it would be nice to
convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically instead
of throwing back an error message.
Mage
...
|
by: Stewart |
last post by:
Hi there,
I would like to calculate a person's age in years (between 2 dates). I
am using the following function for this calculation (source:
http://www.mvps.org/access/datetime/date0001.htm)...
|
by: Darknight850 |
last post by:
I am new to this forum and wanted to say Hello to every one, and i hope i can help every one as much as they can help me.
I have made a query for weekly reports and i have used this to give me the...
|
by: mankolele |
last post by:
Hi all.
I am having a tough time trying to find a way I can use to make restrictions to drop dows for dates, like the following dates are invalid and cannot be allowed to select them, April...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
