Forum Discussion
johnjohn-Peter
Aug 24, 2024Iron Contributor
Create a Refinable managed property which contain a Date field + choice field
I have a sharepoint online date field named DueDate of type Date/Time that allow to enter Date Only (without time). And i choice field named DueDatetime with these values:- 12:00 AM
12:30 AM...
michalkornet
Sep 11, 2024Iron Contributor
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.