How to keep format D/M/YYYY in a date-type table field? 2

[sudakov]

Hello,
I have a date-type field in one of my tables.
After I ran (and compacted) my database on another machine the date-type field format is changed from "D/M/YYYY" to "M/D/YYYY".

Does anyone know how can I restore the format "D/M/YYYY"?

It is important to keep this format since values of the field become field names in a cross-tab query.

Sudakov.

 

[SkipVought]

The FORMAT is just that -- only what is DISPLAYED. The Underlying data has not changed, assuming that you have REAL DATES.

Check your regional settings.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

since values of the field become field names in a cross-tab query
So, use the Format function in your query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sudakov]

SkipVought,
thanks for the explanation.

PHV,
thanks for the solution.