Date format on Windows/IIS server

The server has added the day of week!

[stevew]

We use a small Access database to show training course dates.

Following updates to our ISP's Windows server, these dates are now displayed with a preceding day of week (eg Wednesday, July 23rd, 2003) that completely screws up our schedules page by causing overflows in most of the table cells. This did not happen before, nor does it happen on our own internal server.

The ISP says that everything is standard, and they cannot see a way to remove the day of week within their Control Panel options. They say that there must be an issue with our ASP code or the Access database. (Yeah...) Pity, because they're normally pretty good.

Has anyone any idea how to remove the day of week, so I can tell these people how to do it?

I'd be really grateful as the schedules page is a major focus of our sales effort.

[Dreamquick]

Personally I always prefered;

Day(Now) & "/" & Month(Now) & "/" & Year(Now)

or

Day(Now) & " " & MonthName(Month(Now)) & " " & Year(Now)

...or variations thereof, mostly because it affords you total control of date presentation, something which isnt always possible when you encounter an odd configuration is how the system chooses to display the date/time.

The best fix is to format anything you rely on - never rely on a variable you have no control over - it will change when you least expect it.

Typically this sort of problem relates to the preferences of the logged-in NT user on the server (or default account settings if there is a distinct lack of logged in user).

Haven't seen it in a while, mostly because the first time you see this sort of problem you quickly learn to write more practical code.

- Tony

[stevew]

Thanks for that Dreamquick : I think it's the route we'll take.

I'd still like to know why this has happened, or how to fix it, so if anyone has a view on it ...

[gangstah]

Actually, you CAN modify the way a date is presented using Control Panel options. It's under Regional and Language Options.

I'm onboard with DreamQuick, I never thought of doing it that way (duh), I've always wrestled with FormatDateTime (dumb function). Thanks!

[Dreamquick]

Actually, you CAN modify the way a date is presented using Control Panel options. It's under Regional and Language Options.

Interesting - I was under the impression that was *your* setting, whereas since IIS runs under its own NT account it would have it's own "personal" time/date settings.

- Tony