[AccessD] Birthday in table

Can't you define the field as Date/Time?

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lembit Soobik
Sent: Friday, June 15, 2007 7:04 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Birthday in table

Hi, everybody,
I have tried to define a field in an A2003 table - in fact 2 fields - for
birthday.
thing is, in many cases I know only day and month, not the year.
so I tried two fields: DD.MM as first and YYYY as second field.

a) it wont let me enter a year, and I had to make it Integer instead.

b) I can enter a day and month but it will add the year 2007 (behind the
scenes) and therefore wont allow me to enter 29.02

now I can of course split it up into 3 fields: DD, MM, YYYY, but this would
allow any error resultin in 41.21 as DD.MM

so, how do you handle that? or do you allways have the full date including
year?

thanks for any help

Lembit

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date: 6/14/2007
12:44 PM