RaaS SOAP Report Call Rejects Date Prompt with Invalid Format Error
The error Validation error occurred. Invalid format for date text= 2021-01-01 on attr Prompt - Date 1
What it means
A SOAP call to a RaaS report is trying to pass a date value into a generic Prompt field, such as Date 1, using the report's own custom parameter tags instead of the field Workday actually expects. Workday rejects the date text because it is not looking at that tag for the value at all.
Troubleshooting
- Confirm what the report's actual prompt field is named in the RaaS WSDL, generic reports expose date prompts as p_promptdate1 or similar system-generated tags, not a custom tag matching the field label.
- Regenerate or re-inspect the WSDL for the specific report to see the exact expected element name and date format.
- Test the same prompt manually through the report's web service test page or a simple GET call before wiring it into the SOAP request.
- Verify the date format expected is exactly YYYY-MM-DD with no time component, extra whitespace in the tag also causes this error.
⚡ Quick fix
Replace the custom parameter tag in the SOAP request with the exact prompt element name shown in the report's generated WSDL, keeping the date in plain YYYY-MM-DD format.
✓ Permanent fix
Always generate the SOAP request shape directly from the report's current WSDL rather than guessing tag names from the prompt's UI label, and regenerate it whenever prompts are added or reordered on the report.
Was this helpful?