Database Interface Wizard transposes Date

[Guest]

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 Peter Karlsen[FP MVP]]

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.

 

[Guest]

Jens, many thanks for the tip.
kind regards
Mick

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 [mailto:[email protected]]
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