force date format regardless of locale set

[Leaner79]

Hi,
i would like to set the date format as DD/MM/YYYY on all my tables, regardless of the locale of the machine. How do i do this.

Thanks

 

[PHV]

By setting the display format to "dd/mm/yyyy" instead of "short date"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886