Importing and storing a different date format

I am importing a number of tables from another system that has a large number
of date fields in each file with a format of CCYY-MM-DD. I would like to
store and display the fields in this format but have the field a date field
for calculation purposed (e.g. dateadd etc).

Is there a way to create a data type as a date field with the CCYY-MM-DD
format so the type can be selected when defining in the table create phase so
the fields do not have to be formatted each time (so the CCYY-MM-DD would
appear as a format, like Short Date, in the format drop down list in the
field define screen)?

Or is there better alternatives to the above?

--
Thanks...
Jim Tinder

Dates are stored as dates.

How you choose to display that date is under your control. You can use the
Format property in the table, on a form, in a report, or if you can, the
Regional Settings of Windows.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"Jim T" wrote in message
...
I am importing a number of tables from another system that has a large
number
of date fields in each file with a format of CCYY-MM-DD. I would like to
store and display the fields in this format but have the field a date
field
for calculation purposed (e.g. dateadd etc).

Is there a way to create a data type as a date field with the CCYY-MM-DD
format so the type can be selected when defining in the table create phase
so
the fields do not have to be formatted each time (so the CCYY-MM-DD would
appear as a format, like Short Date, in the format drop down list in the
field define screen)?

Or is there better alternatives to the above?

--
Thanks...
Jim Tinder