Tottaly forget how to change date settings by country

[RezaNana]

Guys..this may sound dumb, but i really really forget how to change date settings by country, bcoz i dont wanna use the US date setting. I have already tried changing the computer system settings on the desktop, but it still appears the same..
can anybody help this lousy questions?

 

[lupins46]

You will have to be more specific about your problem.
Access assumes that the user is entering dates in accordance with regional settings unless you program it otherwise. But if you use dates in code or SQL you must use unambiguous dates. I always use yyyy-mm-dd.

There is no 'Country' setting in Access.

 

[TheAceMan1]

How are ya RezaNana . . . . .

Sounds like your talking about the [blue]windows Date/Time Icon on the TaskBar[/blue] . . . . [purple]Not Access![/purple]

See Ya! . . . . . .

 

[TheAceMan1]

How are ya RezaNana . . . . .

Sounds like your talking about [blue]Windows Regional Settings . . . the Date/Time Icon on the TaskBar[/blue] . . . . [purple]Not Access![/purple]

See Ya! . . . . . .

 

[willir]

Well first, it looks like you went into the Windows "Control Panel" and viewed / corrected your "Regional and Language Options" and selected "English (United States)" -- right???

Most windows applications, and especially Microsoft applications will use this regional setting to control the date format.

Note:
Dates in Access and other systems is actually stored as a number, and the date format is just a way of "counting the days" in the Gregorian calendar and formating the number to the accepted convention.

For example, today, Jan 23, 2005, is represented as the 38375 day, tomorrow is day 38376. If you were to use the debugger / immediate window (CTRL-G) and typed the following:
?Format(38375, "mmm-dd-yyyy")
...the system would display today's date.:
Jan-23-2005

Now, Access uses the system's defualt, but you can change the format with masks in your form, through code, and use of the format command in queries, etc. Using the above example, if you typed:
?format(38375,"yyyy-mm-dd")
...the response would be
2005-01-24

Same data, same date but formatted differently.

If your system date is correct, you are going to have to review the settings for the date control fields on your forms, reports and SQL queries.

Richard

 

[RezaNana]

None of this answer my question.It is actually simple..i just want my date to appeared as dd-mm-yyyy.Thats it. And i know theres no country in Access and yes the regional setting is in the desktop settings. But previously, if this problem happens, i just change the regional settings to Aussies (my country is Malaysia).And it solve..but now...

 

[TheAceMan1]

RezaNana . . . . .

Have you tried setting the [blue]Format Property[/blue] to [purple]dd-mm-yyyy[/purple]?

See Ya! . . . . . .

 

[willir]

RezaNana

Ahhh, well, ask a specific question, get a specific answer; ask a vague question ....

AceMan gave you a very specific (correct) answer.

My answer was vague because I had less direction. However, I think I did show how you can manipualte the date variable output (display) by using the FORMAT command.

 

[TheAceMan1]

Willir . . .

Yes you did! . . . . I just thought I'd [blue]stick it out there in front[/blue] again! . . . [purple]maybe it'll catch[/purple] ;-) . . .

See Ya! . . . . . .