DATE

[Jean-Paul De Winter]

Hi,
I would like to save my date notations like: DD/MM/YY
In table creation I can choose short notation but then dates are saved
like DD/MM/YYYY.

Thanks
JP

 

[Guest]

In the Format Property of the date field in the table write
dd/mm/yy

 

[Douglas J. Steele]

Actually, dates aren't stored with any format: they're 8 byte floating point
numbers, where the integer portion represents the date as the number of days
relative to 30 Dec, 1899, and the decimal portion represents the time as a
fraction of a day.

Ofer's suggestion of setting the format to dd/mm/yy is likely all you need.