Hi,

We've written an app that makes use of the DateValue() function. Specifically I create dates like this:

myDate = DateValue( dd & "/" & mm & "/" & yy )



where dd is the day number, mm the month number and yy the year. This worked fine on our own machines. When we tried this on a brand new machine we got an error. Looking at the documentation it says that DateValue creates the dates based on the short date format as set up on the local machine. The new machines were preconfigured with American standard dates (ie mm/dd/yy) and hence when I tried to set the date to be 31st July 2000 as 31/07/2000 I got an error.
Is there any way to get around this problem and force the system to recognise that I want to view all dates as dd/mm/yyyy ?
TIA
Welly