Create a Refinable managed property which contain a Date field + choice field

Hi johnjohn-Peter

I understand that this question relates to the previous one about the managed property. Since we’ve confirmed that a calculated column can be used as a string, perhaps you could create a calculated column that checks if the time in choice filed is PM (and if so, adds 12 to the hours) to achieve a date format like '2024-09-11T07:00:00Z.' This should allow you to sort the values.

For filtering, you could create separate calculated columns to extract values for year, month, day, and hours, which could then be used for filtering.