12:00 AM

12:30 AM

1:00 AM

1:30 AM

2:00 AM

2:30 AM

3:00 AM

3:30 AM

4:00 AM

4:30 AM

5:00 AM

5:30 AM

6:00 AM

6:30 AM

7:00 AM

7:30 AM

8:00 AM

8:30 AM

9:00 AM

9:30 AM

10:00 AM

10:30 AM

11:00 AM

11:30 AM

12:00 PM

12:30 PM

1:00 PM

1:30 PM

2:00 PM

2:30 PM

3:00 PM

3:30 PM

4:00 PM

4:30 PM

5:00 PM

5:30 PM

6:00 PM

6:30 PM

7:00 PM

7:30 PM

8:00 PM

8:30 PM

9:00 PM

9:30 PM

10:00 PM

10:30 PM

11:00 PM

11:30 PM

now can i create a refinable managed property that combine the values of both fields to generate a date & time field? so i can search, filter and sort items based on this refianble value?

so if i have a combination of the 2 columns as follow:-

22 August 2024 9:00 pm

22 August 2023 11:00 am

and i sort them descending then

22 August 2024 9:00 pm

should be shown before

22 August 2023 11:00 am

is this possible? to manage inside sharepoint search?

​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

1:00 AM

1:30 AM

2:00 AM

2:30 AM

3:00 AM

3:30 AM

4:00 AM

4:30 AM

5:00 AM

5:30 AM

6:00 AM

6:30 AM

7:00 AM

7:30 AM

8:00 AM

8:30 AM

9:00 AM

9:30 AM

10:00 AM

10:30 AM

11:00 AM

11:30 AM

12:00 PM

12:30 PM

1:00 PM

1:30 PM

2:00 PM

2:30 PM

3:00 PM

3:30 PM

4:00 PM

4:30 PM

5:00 PM

5:30 PM

6:00 PM

6:30 PM

7:00 PM

7:30 PM

8:00 PM

8:30 PM

9:00 PM

9:30 PM

10:00 PM

10:30 PM

11:00 PM

11:30 PM  now can i create a refinable managed property that combine the values of both fields to generate a date & time field? so i can search, filter and sort items based on this refianble value? so if i have a combination of the 2 columns as follow:- 22 August 2024 9:00 pm22 August 2023 11:00 am and i sort them descending then22 August 2024 9:00 pmshould be shown before22 August 2023 11:00 am is this possible? to manage inside sharepoint search?  Read More

​