[AccessD] Birthday in table

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


Yes, Rocky, but if I then enter 29.02 (Feb), it makes 01.02 of it, cause it 
thinks its 2007 and there is no 29 Feb in 2007

Lembit



> 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
>
>
> -- 
> 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: 14.06.2007 
> 12:44
> 




More information about the AccessD mailing list