DATE FORMAT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sparkle_guy - 13 Jan 2004 23:10 GMT

I am putting the date in a text box on a form when the form opens using

mytextbox.value = date

The date shows as MM/DD/YYYY

I am working in the UK and would like the format to be DD/MM/YYYY

I have tried using mytextbox.value = CDate(date) but to this doesnt work

I have tried setting the field for the textbox as a date field formated
DD/MM/YYYY but it still doesnt work

Any ideas on how to force the text box to take the format I need

I also have a box in which the date is dispalyed when a check box is
selected so using a predefined field like sent date wouldnt work there.

Thanks in advance paul

Reply to this Message

Hollis D. Paul - 14 Jan 2004 04:27 GMT

> I am working in the UK and would like the format to be DD/MM/YYYY

Basically, you are going to have to write the code to split the Date
Value out into separate MM, DD, and YYYY strings, using the format
command, and the concatenate them as you desire. The final field
should not be a Date-Time field, as it will then convert it back.

A long time ago, and I can barely remember it, I helped a chap from the
UK recode the old word script that converted the MessageClass field to
a new name, and also converted a date to the preferred sequencing. So,
somewhere over there, someone already has it, and it is probably
squirreled away on some resource site. But I have no idea how you
would find it. Is there no UK Google?

Hollis D. Paul [MVP - Outlook]
Hollis@outhousebythesound.com
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

Reply to this Message