SG-1821 CLONE - User Defined Screen - Incorrect retrieved date value with locale format of DD-MM-RRRR |
Description |
|
The retrieved date value for a field on a user defined screen is returned with inverted day and month with respect to the source field date value. This is observed only when the locale setting for date is DD-MM-RRRR and the day selected on the source field belong to the 1st-12th interval. *Steps to reproduce:* # On Administration | Start Center Setup | Queries screen create a new query record with SQL statement like follows (so that it only reads another field value): _select :2_ # on Administration | Screen Configuration | User Defined Screen, create a new UDS record # On the fields tab, add a field flagged as Is Primary Key with sequence 1, then add one date field with sequence 2 # Add another field flagged as Retrieved Value and set Source Field to the previously created Date field, then populate Retrieved Value Query with the query record created at step 1 # Generate the UDS and add it to the applicable user group # Login with a user that has a date locale setting as DD-MM-RRRR and try to create a new record on the UDS # select a date on the source field for a day that belongs to the 1-12 interval (example: 01-05-2022) *Expected result:* The exact same value should be displayed on the retrieved field *Actual result:* The day and month values are inverted (from example above, it would result in a retrieved value of 05-01-2022) |