Hi all.

I am working on a financial application that runs in a multi-tier environment (web server, app server and database server). Alas, problems with dates due to regional settings!! If the date format of the web server does not correspond with the date format of the app server the day and the month are swop around in some instances.

Does anyone know of a way, other than to convert the dates to strings (which I know will do the trick), how to ensure correct date formats throughout the application?

This is a problem that has been going on for about 2 years and I am unfortunately the one chosen to fix it. So, any help will be much appreciated.

jck