In report based on 'SQL with parameters' DateTime parameter requires value in mm/dd/yyyy (US) format instead of local date format.

book

Article ID: 171665

calendar_today

Updated On:

Products

Workflow Solution

Issue/Introduction

In report based on 'SQL with parameters' DateTime parameter requires value in mm/dd/yyyy (US) format instead of local date format.

Cause

Product defect.

Environment

Workflow 7.5 SP1
Workflow 7.6
Workflow 8.0
Workflow 8.1

Resolution

This issue is resolved in Workflow 8.5 and newer.

Couple notes about the behaviour in 8.5:

  • Whichever language is set, the separator is irrelevant, '/', '-' or '.' all behave the same.
  • English (US) mm/dd/yyyy works as expected. It does show an error if incorrect value is entered, for example 25/12/2018.
  • 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.