[AccessD] Birthday in table

Default the date, not assign it LOL. Change the year in this case.

On 6/15/07, Lembit Soobik <lembit.dbamail at t-online.de> wrote:
>
> 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
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>