I am performing an incremental refresh on the data in QuickSight, but it’s failing with an “invalid function argument” error at a specific date value. I downloaded the CSV and manually checked all records for 07-09-2024 for any invalid data, but everything seems correct
Error type:
SQL_INVALID_PARAMETER_VALUE Learn more
Error details:
INVALID_FUNCTION_ARGUMENT: Invalid format: “2024-09-07” is malformed at “24-09-07”
It looks like the issue stems from a date format mismatch. While QuickSight expects dates in the format YYYY-MM-DD (2024-09-07), the error indicates that at least one value is being interpreted as YY-DD-MM (24-09-07).
Ensure that all dates in your data source dates are in the correct format YYYY-MM-DD. Sometimes, even if the value looks correct, format might be causing issues.
Once you’ve corrected the date formats, try running the incremental refresh again. If the issue persists, please share the error record file from the dataset refresh history so we can check further and assist you.