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