date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Abeer - 16 May 2005 18:22 GMT

how do i convert the short date format from mm/dd/yy to
dd/mm/yy

Reply to this Message

Duane Hookom - 16 May 2005 18:48 GMT

Set the format property of the text box on the form or report that displays
the value.

Signature

Duane Hookom
MS Access MVP

> how do i convert the short date format from mm/dd/yy to
> dd/mm/yy

Reply to this Message

Allen Browne - 17 May 2005 02:08 GMT

Duane's answer is perfect if you just want to change one print out on a
report.

But if you live in a country that uses the dd/mm/yy format, you will want
this changed for all your programs. Open the Windows Control Panel. Go to
Regional Settings. Set your date format there. Access will use the setting
you choose there.

There are still a few gotchas for people who have non-US dates. See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Set the format property of the text box on the form or report that
> displays the value.
>
>> how do i convert the short date format from mm/dd/yy to
>> dd/mm/yy

Reply to this Message