Highlight matching cells in temporal cell types within the Record Selector

[seancolsen]

Current behavior

• In the Record Selector, searching for a record via text columns show results that highlight the cells which match and don't match the search query.

• Columns of type "Date", "Date & Time", "Time", and "Duration" do not highlight the matching values like this.

• Notice how in the image below we have a search term 04/15/2025 which matches
  the cell in the first row, but that matching cell is not colored yellow like the other matches

  

Desired behavior

• The temporal column types highlight the matches and non-matches.
• They should not highlight any sub-string matches (as the text columns will).
• The highlighting should be done by comparing the canonical values so that if the user enters a date like "7/3/2020", then a cell that displays a date of "07/03/2020" will be highlighted to match (even though its format differs from the format in the search query).

Implementation

• We should probably make changes in DateTimeCell.svelte.
• Notice how TextBoxCell.svelte accepts a searchValue prop? We should add that prop to DateTimeCell as well. (The searchValue prop is already passed to DateTimeCell via CellFabric.svelte.)
• Then DateTimeCell should use dayjs to attempt to format the search value to match the canonical value returned from the API. In the screenshot above, the API value is "2025-04-15 AD". We need to format dates, date-times, times, and durations to match those API formats. We may need to consider timezones in some cases too.

[github-actions]

This issue has not been updated in 90 days and is being marked as stale.

[dikwickley]

This issue is still present. I will be working on it.