Hi.



I've been using Access 97 and ASP for ages now, and have

recently noticed that the dates are being handled in

American Format. Can I change this? If so, how?



I've been into Regional Settings and it's set to European.

But dates are still shown the other way in queries.



This makes it difficult when writing queries as I have to

flip the date all the time. Is there another way?!



Many thanks

Craig.

The only way I know is to ASP-code it:



date_mod is the American version:



date_moda=date_mod.slice(0,5)

date_modb=date_moda.slice(0,2)

date_modc=date_moda.slice(3,5)

date_mod=date_mod.slice(5,10)

date_mod=date_modc+"/"+date_modb+date_mod



regds



Simon Garstin



----- Original Message ----- 

From: Craig Flannigan <ckf@k...>

To: Access <access@p...>

Sent: Monday, March 26, 2001 2:31 PM

Subject: [access] Date Formats





> Hi.

> 

> I've been using Access 97 and ASP for ages now, and have

> recently noticed that the dates are being handled in

> American Format. Can I change this? If so, how?

> 

> I've been into Regional Settings and it's set to European.

> But dates are still shown the other way in queries.

> 

> This makes it difficult when writing queries as I have to

> flip the date all the time. Is there another way?!

> 

> Many thanks

> Craig.

> 

>