[AccessD] Birthday in table

Lembit Soobik lembit.dbamail at t-online.de
Fri Jun 15 09:03:55 CDT 2007


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




More information about the AccessD mailing list