Support Article
Date format on filter is different than the table column
SA-62727
Summary
The date formatting on the filter option is different than the format mentioned in the table column.
Error Messages
Not Applicable.
Steps to Reproduce
- Log in to the application
- Configure a repeating grid which can be filtered
- Set the source of the repeating grid as a report definition
- Configure a DateTime field as one of the columns of the repeating grid with custom format (dd-MM-yyyy)
- Run the flow
Root Cause
Filter panel range options are displayed based on the property data type. Data is displayed based on the clipboard value instead of the configured column format.
Resolution
Perform the following local-change:Modify the column level filter settings to use Filter by Format to view the control markup instead of the clipboard value in filter panel.
Published September 11, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.