Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Date format

edited November 2016 in Server
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.

Comments

  • edited December 2016
    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.