I have a date field in my Access database, automatically entered on creation
of a record with the date() command. In format for the field I sk it to
format as "short date". No problem it formats to the english way of writing
dd/mm/yyyy. As soon as I use the Wizard to update a record it transposes the
date into mm/dd/yyyy. As the date field is used to calculate time lapsed
since the record creation, its playing havoc. Any ideas please, thank you in
advance.

Because there is so many ways of writing dates I don't recommend using a
date field. Use a text field instead. Then in the Form make sure your
users input the date in the "right" way. For instance by using dropdowns
for day, month and year respectively.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

> -----Original Message-----
> From: Mick [private.php?do=newpm&u=]
> Posted At: 11. maj 2005 17:38
> Posted To: microsoft.public.frontpage.client
> Conversation: Database Interface Wizard transposes Date
> Subject: Database Interface Wizard transposes Date
>
>
> I have a date field in my Access database, automatically
> entered on creation of a record with the date() command. In
> format for the field I sk it to
> format as "short date". No problem it formats to the english
> way of writing
> dd/mm/yyyy. As soon as I use the Wizard to update a record
> it transposes the date into mm/dd/yyyy. As the date field is
> used to calculate time lapsed since the record creation, its
> playing havoc. Any ideas please, thank you in advance.
>

Jens, many thanks for the tip.
kind regards
Mick

"Jens Peter Karlsen[FP MVP]" wrote:

> Because there is so many ways of writing dates I don't recommend using a
> date field. Use a text field instead. Then in the Form make sure your
> users input the date in the "right" way. For instance by using dropdowns
> for day, month and year respectively.
>
> Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
>
> > -----Original Message-----
> > From: Mick [private.php?do=newpm&u=]
> > Posted At: 11. maj 2005 17:38
> > Posted To: microsoft.public.frontpage.client
> > Conversation: Database Interface Wizard transposes Date
> > Subject: Database Interface Wizard transposes Date
> >
> >
> > I have a date field in my Access database, automatically
> > entered on creation of a record with the date() command. In
> > format for the field I sk it to
> > format as "short date". No problem it formats to the english
> > way of writing
> > dd/mm/yyyy. As soon as I use the Wizard to update a record
> > it transposes the date into mm/dd/yyyy. As the date field is
> > used to calculate time lapsed since the record creation, its
> > playing havoc. Any ideas please, thank you in advance