Display what day the date is ?

[on-2]

This used to be an easy one. . . but has anyone noticed that long date format no longer shows the day on the end? I have looked through the regional windows settings too and i cant find it anymore. What i would like is to group some results by date on a form with it displaying the day as like a diary style listing. Any help would be greatly appreciated....

 

[RuralGuy]

What version of Access? I use ac2002 and my long date has the Day, Month Day, Year!

 

[on-2]

Its access 2000 on windows xp pro. I have another pc here running access 2000 with xp and that doesnt show it either.? Nuts??

 

[on-2]

Aha ! made a partial break through - if you change the regional settings to United States the day then appears, however change it back to United Kingdom and it disappears ???

 

[on-2]

solution - - overtype the long date format in the control panel / regional settings section to

dddd, dd MMMM, yyyy

 

[RuralGuy]

Glad I was able to help! You can fix my problems any time!

Thanks for posting your solution.