Very Strange Date problem (1 Viewer)

[losthome]

Hi There,

I am having a very strange issue that has popped up that I can't explained. I thought my client was nuts, until I view this problem for myself.

Problem:
At my clients office, Dates switch to MM/DD/YY

At my home and other computers I have tried, Dates switch to DD/MM/YY

The dates are backwards only at his office????

Any suggestions on why? He is getting confused because dates don't enter properly

Thanks

Jennifer

 

[madhouse]

You might want to check how the PC dates are formatted in the Regional Settings. Access will take the dates from the PC's Regional Settings unless they are specifically formatted within the code.

 

[Dave Eyley]

Somebody in Canada with a UK date problem?

I was driven nuts too for a while.....until I spoke to our IT guys about windows dates issues.

To get over it, whenever I need to input a date into the database and use it in a search routine I use the FORMAT function.

MyDate=Format(NewDate,"mm/dd/yy")

This ensures that the date format is in the right format for Access to work on properly, and you don't have to change the Regional settings if you don't want to.

HTH

Dave Eyley