Date format

rbuser

Hi,

We ran into a problem with the date format.

When a report is using a searchcriteria with date format we get an
error message: '31-12-2013 is not a valid date format (mm-dd-yyyy).
So the form is expecting a dateformat mm-dd-yyyy, but we are using
dd-mm-yyyy.

Is there a way we can configure this? Or what settings is used for
this?

Thanks.

Andre Konijnendijk.

nardmoseley

Hi Andre,

For the WebTier or ClientReport, the date format is determined by the Delphi
TFormatSettings, which is initialized to the Windows regional settings. You
can either modify the Windows regional settings or modify the
TFormatSettings. A simple test on my machine, if I use English (United
States) the format is M/D/YYYY, if I use English (United Kingdom) the format
is D/M/YYYY.

For the SQL that is generated, the date format is determined by the
DataSettings.DatabaseType. Different database engines require different
formats.




Best regards,

-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com