Hi everybody

Again I am facing some problem with date format.

By default Access Format is mm/dd/yy

But I want to store and show the date format as dd/mm/yyyy.

Pl advice me.

thanks
Subho

Once more with feeling...:D:D:D

Access doesn't store dates in a human recognisable format.

Dates are stored as numbers. The integer part of the number records the date - by showing how many days after a certain fixed date it is.

The decimal part of the number records the time as a fraction of a whole day.

Whenever a date is displayed Access goes through a translation routine and converts this number into a recognisable date\time. When you change a record it reverses the translation and converts it back into a number.

The default format for display is taken from the Windows regional settings - The short date format I think. So, if your short date format is set to dd/mm/yy then all your dates will be displayed as dd/mm/yy, unless you override it using a formatting command.

In short, whenever you display a date to the user set the format to dd\mm\yyyy and that's what they'll see!


Brian Skelton
Braxis Computer Services Ltd.

Hi Subho,
Just to elaborate, for the field you wish to format, go to the properties dialog box, under format & you can choose from the predefined list of formats, or define your own.
You can also ensure proper formatting on entry, with an "Input Mask",
from the same dialog box under "Data".
You can even, have it entered in one format & have it displayed in another. eg; use a shorter, easier, or more intuitive format for entry (Input Mask), but it will be displayed as you dictate with the format property.
Sorry, if you knew this already?