The test values for Aggregate filters requires YYYY-MM-DD, but data in the results is displayed as MM/DD/YYYY. If you enter MM/DD/YYYY into the test values, you get an error.
This is very confusing. See this thread for more info.
https://www.outsystems.com/forums/discussion/36874/date-error-in-test-values-for-aggregate-due-to/
Just ran into this issue when copying a value from the debugger (indicating what is being passed into an sql query) into the test value for the same query, expecting it to be in the same format. This difference doesnt seem to serve any functional purpose and just makes the platform feel poorly put together. The debugger value being in between ## will make most think it is already in the right format.Really it makes no sense that its like this currently, and still an issue catching developers 7 years later!