Dates in remote dataset

Hello,
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?

Interested if you found a solution for this as I have the same issue.

Unfortunately we have not.

Trabalho com a formula de Data em JSON e para mim funciona perfeitamente.
Posso ver sua URL JSON?