the date format YYYY MM DD - why??
because when sorting, it is chronological

it also avoids issues like 08/05/2024 is the eighth of may in the UK but the fifith of august in the USA

as for the rest of your query, no idea sorry