is there a simple way to intercept the "header click sorts" method so If I click on column 3, it sorts by column 7 which is hidden?

Simply sorting a datetime2 column with 3 digits of milliseconds, does not work, because the milliseonds are confusing. so converting to a "sortable date" string fixes the sort, but breaks the display.

what do?