选择当前日期，如果它不存在则寻找未来的其他人从过去获取最高值

I have some data with multipe dates across some rows in a table. what i want to do is get a date thats currently active if there is no active date then i want to take a future one, if that one also doesnt exist then il take one from the past.I have some data with multipe dates across some