Losing date zeroes in Win2K 1

[kramerpup]

I just switched to Windows2000, reinstalled Office2000, and now my date fields in tables are showing no zero placeholders.

For example, instead of 09/25/97 I get 9/25/97, or instead of 04/04/99, I get 4/4/99. I checked the database (which is stored on a network) on the other Win98 machines in the office, and all show the leading or placeholder zeroes. I have not changed a thing in the db otherwise.

Anybody know what could cause this?

 

[Taff07]

Hi,


Have you checked any regional date settings within windows itself, Format within there can effect the default format.

Hope this helps

Ian

 

[kramerpup]

Yep, my date setting was set to D/MM/YY in the regional settings. I'm new to WIN2K, no excuse, but those kinds of things are supremely frustrating!

Anyway, much thanks; you just saved me hours of writing band-aid code. s-)