Date Input Mask and Value

[Guest]

I am attempting to place in input mask for a date with the following:
99/99/0000;0;# which works fine, however I want the date to be stored as a
long date, example 10 May 2006. How do I do this.

Thanks for your help.

 

[SusanV]

Dates aren't stored in a format you would recognize - the formatting takes
place upon view. You should set the format the way you want it for any
particular in the report or form by using the properties of the control on
that form. You can also set it on the properties of the field in the table
itself.

 

[Guest]

If you are using a DateTime datatype the date is stored as a decimal number
and is formated when displayed in a query, form, or report.