Data Filter Improvements for Date handling

Version: 2021b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-23391

  • Use simple edit box for the Value option in Simple Date Filter dialog instead of the Date Time Picker. (Can set @DP = 1 if you prefer to use the picker control.)

  • Use the 1st non-missing value instead of current time as the initial value for the Value edit box in Simple Date Filter dialog.

  • For Date value with time info but display only with date part, improve the equal condition handling to only compare the date part.

  • Use simple text for the Filter label. For example, >=14 or <30

  • When use Simple Date Filter, the date value shows in Filter label string will follow the column display always.