date/time format

[Guest]

I'm trying to create a date function where the output would be in the format:
dd-mmm-yyyy. In a previous table I had created(in a different database,
using the same version of ACCESS) the Medium date format (from the drop down
list) is in the above format. However, in a new database I am creating the
Medium date format from the dropdown list is now in the form: dd-mmm-yy.
I've tried using 99\->L<LL\-0000;0;_ as my input mask (which is what I have
for my earlier database that gives me the medium date I am looking for). Why
is the medium date format from the dropdown list different for my new
database eventhough I am using the same version of ACCESS. Am I doing
something wrong? Thanks.

Ray

 

[Guest]

Input mask has nothing to do with the output format of a date. Access
actually stored dates as a number and you must define how you want to see the
date presented in forms, reports, and queries.

For example today is 38887 which is that many days from 30 December 1899.
You might type in 19-June-2006 but Access stores it as 38887. The date and
time as I type this is: 38887.614224537

To see the date presented in a particular way in a form, report, or query,
use the Format function:
Format(Now(),"dd-mmm-yyyy")

The way something like Medium date looks is defined by the Regional Settings
of the computer and not really Access at all. Are you using different
computers for the different databases?