2. ASPRunnerPro General questions
  3. UK format date error
This topic is locked

UK format date error

 		2/13/2010 11:02:58 PM
ASPRunnerPro General questions
L
 Levski author

Hello,
I am using 6.2 with SQL 2008. All system/project locales are UK.
The following code:
dal.Accounts.Value("Date")= DATE

dal.Accounts.Update()
will produce a US date instead of a UK date, meaning the days and months are reversed. Apart from producing incorrect dates, anything after the 12th day is no longer a valid US date and a conversion error is produced.
Please help.
G
 		glazer 2/15/2010



Hello,
I am using 6.2 with SQL 2008. All system/project locales are UK.
The following code:
dal.Accounts.Value("Date")= DATE

dal.Accounts.Update()
will produce a US date instead of a UK date, meaning the days and months are reversed. Apart from producing incorrect dates, anything after the 12th day is no longer a valid US date and a conversion error is produced.
Please help.


Same problem with PHPRunner5.2. Import assumes USA data order rather than UK date order, even though Export does create file with UK order.
Sergey Kornilov admin 2/15/2010

Levski,
try the following:

dal.Accounts.Value("Date")= Year(Date()) & "-" & Month(Date()) & "-" & Day(Date())

dal.Accounts.Update()


We'll check if this type of conversion can be done automatically.