Hi, is there a way to add a customized sort to a view?

I have 2 fields, start date & end date. Id like to sort by start date if the current date is <= start date, otherwise end date should be used.

Is this possible with Airtable?
Thanks.