Enter dates in short form, but store them in Long Date format

[Guest]

I need to have an individual enter dates in short date format (01/01/06) but
they need to store in long date format (Sunday, January 1, 2006). I need to
use this field in a mail merge. Can you help me with this.

 

[Allen Browne]

Internally, Access just stores dates as numbers. They have not format when
stored. The format is applied at display time.

You can therefore enter the dates on a form in a text box that has its
Format property set to Short Date. Then display them on a report in a text
box that has its Format property set to Long Date.

 

[Guest]

Hi Deb - Access stores dates as a number - each day / time is different. For
example today is 38761, tomorrow will be 38762. This makes it possible to
find the difference between dates easily. Date formats are only used for
disply or printing so all you need to do is change the format of the mail
merge field and for the display in the form on entry.
Hope this helps - yrs Dika