rewrite rule to redirect to the most recent date permalink

I don’t think this is a good approuch.
I think it’s best to redirect your page at mycpt. let it get the last date in php using your get_posts. And let the page redirect to where you need to be.
Don’t go auto updating your .htaccess, that’s not what it is made for.