Importing and storing a different date format

[Jim T]

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?

 

[[MVP] S.Clark]

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.