A problem can arise if the timezone of the server is different from yours. In that case exports might contain wrong dates. E.g. you set something to 2023-09-08 00:00:00 CET, but that is 2023-09-07 22:00:00 in UTC (time zone + daylight saving difference). So it will actually be stored as 2023-09-07, but displayed as 2023-09-08 for you, but not in an export...
So in one of my applications I decided to turn off Localized for all dates (where the time is not important).
This actually causes the dates to be stored in UTC, so I needed a “data fix” microflow that moved the 23:00:00 times to the next day.
And in all microflows/expressions I used the *UTC versions of the date.
This solved all the discrepancies.