I'm trying to call a soap method where one of the inputs is a date. All the other input work fine.
The date-format in the excel sheet is DD-MM-YYYY but when SoapUI Pro reads it, it comes out as DD/MM/YYYY. I.e. it is separated by slashes instead of hyphens. Now the request does not adhere to the xsd schema and hence I cannot send it.
So the question is how do I change the date format of the input in SoapUI?
Thanks in advance.
Solved! Go to Solution.
Thank you for your reply.
However your proposed solution does not fix the problem.
The problem is that SoapUI changes the dateformat compared to the format in the Excel file and then the request does not validate against the xsd schema. So I cannot send the request.
I do not have the possibility to change the schema that is validated against.
Thank you for taking you time to reply.
I have investegated further, and it does seem to have something to do with Excel. It is a strange issue I think. In Excel I have formatted the Date-field (YYYY-MM-DD) which is expected, but it still shows up in as YYYY/MM/DD.
Anyway in Excel, changing the column/cell from type Date to type Text and then format the (text) string as a date (YYYY-MM-DD) seems to be a workaround that works (like Vallarasu suggested), but not really the solution I was looking for as it is quite tedious changing hundreds of date (types) to string types in Excel.
*EDIT*... or perhaps not so tedious using the TEXT function in Excel 🙂