In report based on 'SQL with parameters' DateTime parameter requires value in mm/dd/yyyy (US) format instead of local date format.
Updated On:17-08-2018 00:17
<p>In report based on 'SQL with parameters' DateTime parameter requires value in mm/dd/yyyy (US) format instead of local date format.</p>
<p>This issue is resolved in Workflow 8.5 and newer.</p>
<p>Couple notes about the behaviour in 8.5:</p>
<li>Whichever language is set, the separator is irrelevant, '/', '-' or '.' all behave the same.</li>
<li>English (US) mm/dd/yyyy works as expected. It does show an error if incorrect value is entered, for example 25/12/2018.</li>
<li>English (UK) dd/mm/yyyy, Estonian dd.mm.yyyy and English (India) dd-mm-yyyy all accepted the normal values as expected. However, technically incorrect values - for example 12-25-2018 - were also accepted and had day and month values automatically switched.</li>