Dates in remote dataset

I input a date from a remote JSON with the format YYYY-MM-DD and that works perfectly when you change the type from string to date just until it tries to refresh the date from the remote source, then it says that the format is wrong.
We can’t change the remote data and need the column to be date so we can change the look of it with a formula.
Someone has an idea why the refresh does not work but if I change from string to date there is no problem?