UK and US Date Format

[asifit]

I am using ASP With Access database and I am trying to save date, From 03/03/04 to 20/03/04, For example.
It save date in two formats, US and UK Format.
03/03/04
03/04/04
03/05/04
03/06/04
03/07/04
03/08/04
03/09/04
03/10/04
03/11/04
03/12/04
13/03/04
14/03/04
And So on. First date is 03/March/04 second is 03/April/04 and when it gets to 13 it changes to UK Format and starts from 13/March/04.

Can any one help how to save date in UK Format only ASAP? Needed urgently.
I have also checked control Panel for Date and time settings, every things seems alright.

Thanks,

[wackal]

check in the control panel under regional settings, make sure it says English(British)

[asifit]

Thanks for you mediate reply.
I checked control panel and it is English (United Kingdom).

In my coding I use cDate function
Does this function make any difference?

[wackal]

can you post your code?

[aspdaddy]

>03/08/04

This format is probably a bad idea, use this instead and it cant be misinterpreted

03-AUG-2004