Date formatting dd/mm/yyyy

[Ange T]

Hi there,

I've read stacks of articles on this subject in this newsgroup, so
forgive me that this is just another one. I've tried almost all the
suggestions offered, and am still having no luck. I'd really
appreciate any help/advice that can be offered.

I'm trying to obtain and then store all sorts of data, some of which
are dates. In all cases, I would like dates to be in European format
(ie. dd/mm/yyyy). My computer's regional settings are dd/mm/yyyy.

To do this, I have ensured that all the text boxes on my form are in
the format dd/mm/yyyy. All fields in the tables that I am saving to
have the data type 'Date/Time' and their format is specifically
dd/mm/yyyy.

However, when I use the following SQL to save the value in my text box
to the table, the date is automatically converted to mm/dd/yyyy.

"Update TblDetail Set ReviewDate = #" & txtReviewDate.value & "# where
ID = 1"
-- where txtReviewDate.value = 01/05/2003.

If anyone can suggest a simple way of ensuring that exactly what is in
the text box is saved to the table to be exactly the same, that would
be MUCH appreciated! I am trying to avoid actually storing the dates
as text, as any subsequent queries to sort by date would involve
changing all my code to use CDate().

Thanks, Angela

[Allen Browne]

Ange, I've been using Access in a country with dd/mm/yyyy dates since
version 1. My experience is that there are three cases where Access gets our
dates wrong. Details:
http://users.bigpond.net.au/abrowne1/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Ange T" <sm*************@yahoo.com> wrote in message
news:b7**************************@posting.google.c om...

Hi there,

I've read stacks of articles on this subject in this newsgroup, so
forgive me that this is just another one. I've tried almost all the
suggestions offered, and am still having no luck. I'd really
appreciate any help/advice that can be offered.

I'm trying to obtain and then store all sorts of data, some of which
are dates. In all cases, I would like dates to be in European format
(ie. dd/mm/yyyy). My computer's regional settings are dd/mm/yyyy.

To do this, I have ensured that all the text boxes on my form are in
the format dd/mm/yyyy. All fields in the tables that I am saving to
have the data type 'Date/Time' and their format is specifically
dd/mm/yyyy.

However, when I use the following SQL to save the value in my text box
to the table, the date is automatically converted to mm/dd/yyyy.

"Update TblDetail Set ReviewDate = #" & txtReviewDate.value & "# where
ID = 1"
-- where txtReviewDate.value = 01/05/2003.

If anyone can suggest a simple way of ensuring that exactly what is in
the text box is saved to the table to be exactly the same, that would
be MUCH appreciated! I am trying to avoid actually storing the dates
as text, as any subsequent queries to sort by date would involve
changing all my code to use CDate().

Thanks, Angela

[Ange T]

Allen and Steve,

Thank you both so much!! Steve, inserting your simple combination of
format() and ## did the trick perfectly. I should have posted the
question about a week ago when I first started picking up this
problem...

Allen, your URL was really useful in explaining what on earth the
problem was.

Thanks again, vm appreciated! Angela