***NEED HELP: Date Format Display Issue***

[dsk525]

Hi All,

I have an ASP application using 2000 Access database. I am frustrated with a date display issue on the ASP pages.

I would like the date to be displayed as date first and then the month (U.K. style), however on the ASP pages it is showing as month first and then date (i.e. 10/21/1999). Access database itself is showing the dates properly, that is in U.K. style (date first and then the month). I am not sure why the ASP pages are not picking up the same format as Access database.

This is what I have done so far to resolve the issue:

Since Access uses the regional settings in Microsoft Windows Control Panel to determine the display format for date, time, currency, and other numbers, under Regional Options I have done the following:

I have confirmed under the General tab, "my" locale (location) is set for English (United Kingdom)
I have confirmed under the General tab, "Language setting for the system" and it indicates "Western Europe and United States" as the default.
I have confirmed under the Date tab, the short date to be shown as dd/MM/yyyy and the long date to be shown as dd MMMM yyyy.
I have confirmed under the Input Locales tab, English (United Kingdom) as the "Installed input locales" and it is set as default.

Any help would be MUCH APPRECIATED!

Thank you in advance.

 

[mmsbasd]

I'm not familiar with ASP pages but could it be possible that it's getting the settings from the SERVER and not the local machines? That would explain why none of your changes are having an effect.

Also, check and make sure, in the Access database, that the format is configured for the table field and not just a query or report view of the data. I would think that the format of the table properties for that field need to be in the proper format.

Hope this helps. Michael
BASD IS/IT Dept