Upps, a small mistake in the order of the dates, sorry, I was doing trial and error and I mixed up the text on my clipboard.
The query has the date ranges in reverse order, OverPass cannot interpret the date range and uses the most recent one or the first.
Only 2 numbers need to be changed.
[adiff:"2023-01-01T00:00:00Z","2025-01-01T00:00:00Z"]; nwr["amenity"="restaurant"]({{bbox}}); compare(delta:1); out geom meta;
The following is the tutorial I use for various complex queries that I don’t find in the OverPass API.
https://dev.overpass-api.de/overpass-doc/en/analysis/museum.html