Using Date$

[Mav505]

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

[jbart]

Have you tried using format?

format(date$,"dd/mm/yyyy")

[Mav505]

Yeah ........ It's writing todays date into the Database as 12/04/2000


help

[Mav505]

I don't know if this will work or how it can be done, but could someone tell me if it is possible to take the Date from Windows in some way other than using Date$ and if so how?


Cheers


Paul

[jbart]

I can't help you with the Access issue, but you can get the date by using Now.

MsgBox Now