This artful approach that Terry describes is the best way to go about it, to be sure. Give it a try, you will learn a lot about your Avid’s capabilities as you proceed.
Boris RED (Avid FX) has a day for night filter, too, that might work for you. It is customizable, like all Boris filters, so you may get what you’re looking for with this approach.
Regards,
Joe Womble