I have a db setup on a PC with regional settings set to English (Australia). The date fields are:
dd/mm/yyyy

When I do a select form elevateDB manager, the field is returned as 'yyyy-mm-dd'

When I select from delphi and read the field as .asString I get 'dd/mm/yyyy'

-This is what I want.

I have deployed to a machine which had regional settings set to English (United States), dates as 'mm/dd/yyyy'

I reset the setting to 'dd/mm/yyyy' on the machine, but when I select from delphi and read the field as .asString I am still getting 'mm/dd/yyyy'

Are there further config settings for elevateDb or inmy components that I need to reset?

Bryn,

<< When I do a select form elevateDB manager, the field is returned as
'yyyy-mm-dd' >>

The EDB Manager forces all date/time displays and edits to ANSI format,
which is the SQL standard:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=2&topic=34

<< I reset the setting to 'dd/mm/yyyy' on the machine, but when I select
from delphi and read the field as .asString I am still getting 'mm/dd/yyyy'

Are there further config settings for elevateDb or inmy components that I
need to reset? >>

If you changed the regional settings on the actual machine, then your
application should return the date/time strings in the regional settings
format, provided that none of the TFields or data-aware controls being used
are re-formatting the date/time strings into a specific format.

Did you restart the application after changing the regional settings ?

--
Tim Young
Elevate Software
www.elevatesoft.com