2. ASPRunnerPro General questions
  3. UK Date Problem
This topic is locked

UK Date Problem

 		3/26/2003 3:22:06 PM
ASPRunnerPro General questions
author

I use MS Access to edit and update my database but despite setting my 'Reginal' settings to UK (In my control panel) and despite the database showing that indeed the UK date format was in order, ASP Runner seems to translate all dates back into the American MM/DD/YY when listing, instead of the required DD/MM/YY
As I am using the database to display a list of 'What's On' in a UK venue, it becomes confusing for my viewers especially around dates like 04/05/2003 which in UK is the 4th of May, but in the American looks like April 5th.
How can I change this aspect?
500023 3/26/2003

It's Ok. I found the answer to this in AspRunner's help files. I see that I can make certain fields 'editable' and change the formats before saving the project.
Sorry to have troubled anyone.
admin 3/26/2003

Hi,
you also can use formatting options like "Short date format" and "Long date format" to display your date values proper way.
Sergey Kornilov