Hey all,


I hope this is a simple one. As far as I understand it Date$ takes the system date from your PC. It doesn't give the value of this in the same format as your Regional setings define in the Windows Control Panel. The PC I'm ising has come from the States and so Date$ always gives me the system date in the format of mm/dd/yyyy. This has been causing me a few problems in that when I try to write the date to an Access Database it writes in the format of mm/dd/yyyy e.g. todays date, 04/12/2000, if I use Date$ to write this to Access it comes up as 12/04/2000 even though the Access settings are set to dd/mm/yyyy as per the Regional Setting in the Control Panels. Is there anyway to force Date$ to give the date in the format of dd/mm/yyyy. I've checked the System BIOS Setup and there doesn't seem to be anyway to change it from there.



Any help would be greatly appreciated.


Cheers

Paul