Date Formats

[azizrasul]

At the moment I have the UK format of the date in Regional Options in the Control Panel i.e. dd/mm/yyyy.

However if I place Date$() in a query, I obtain the US format i.e. mm/dd/yyyy? Why do I not obtain the UK format, in this case?

 

[SydneyGeek]

Happens in Excel too... I'm pretty sure that many of the built-in date functions (and I've seen it in non-MS apps too) output dates and date strings in US format. The International versions of the apps still have the US functions...

Denis

 

[azizrasul]

Is their a setting somewhere that we can change to automatically revert to the CP setting? I know that I can resolve the issue using the Format function, however I'm concentrating on how to change a global setting if possible.

 

[bat17]

I think that if you use Date() rather than Date$() it will use the local settings

Peter

 

[azizrasul]

For reasons to long to explain, I want to use Date$(). Why does the Date$() not follow the CP setting when Date() does?

 

[WillR]

For reasons to long to explain

But not too long to post this here as well eh? :wink:

http://www.utteraccess.com/forums/s...=290256&page=0&view=collapsed&sb=5&o=&fpart=1

I think your post got answered for you there....

 

[azizrasul]

Copying and pasting doesn't take too long as I imagine u will know yourself.

I'm quite capable of checking my post on other forums without your prompts. Mny thanks.