You’ve got 2 queries in the code and I don’t see the need for the second. Altering the first query in the way I mentioned will order the post by the two fields, there wouldn’t be any need to do additional queries on every date.
Also, this is incorrect
'type' => 'date'
ACF does not store date fields in date format, it stores them like YYYYMMDD so this query will find nothing that matches the date.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users