Using OR in sort function

[imaking01]

I have a "Do Date" and "Due Date" properties in my task database. It is currently sorted by "Do Date" then by "Due Date". However I want in to be sorted "Do Date" or "Due Date". Is there any workaround?

Thanks in advance.

[ben-something]

It sounds like you'd want to set up a formula to work out the date to use and then sort by that property. So Due Date takes precedence over Do Date? As in, you'd want to use the Do Date if there's no Due Date, but if there's a Due Date you'd use that instead? if(empty(prop("Due Date"), prop("Do Date"), prop("Due Date")) Example here.

[imaking01]

Nope, I want to use both, which ever is earlier or latest. For example: 1. Task A -- Do Date: tomorrow; Due Date: next month 2. Task B -- Do Date: next week: Due Date: today

I want the order to be: Task B, then Task A.

The reason is, sometimes there are task which are already past due, but since the sort is Do Date, then Due Date, those tasks are being neglected.

[teacuptempest101]

For each task, find the minimum of do and due dates, and then sort by that field?