More than likely the format of the data from Excel does not match the date format that the Mashup Server is expecting. You can find information about the date formats that Presto supports in documentation at:
* MDC Resources > Documentation. Choose Developer docs and search for "date format"
* http://www.jackbe.com/prestodocs/v2.7.0/prestolibrary/index.html. Search for "date format".
Try the yyyy-mm-dd formats (or variations such as yyyy/mm/dd).
Sara, technical writer/jackbe
When we talk about Mashlet using an Excel service then there is a very high chance of getting errors. The date range should be correct with the excel functions that you are using with and the inpult action with the data type should also be correct. This is a very complicated error and sometime it also says unable to run the EMML Mashup script which is installed with the presto version. I am also very much confused with this error and I would also be very happy to solve this error. I believe this error can be solved by a expert programmer and is not in the hands of people who are working on their own excel functions. So please do let me know this error type I am also very mcuh eager to know about this error type which is really new for me.
Are you using Presto 2.7? If you are, one potential issue is that Wires (and mashups in general) expect dates to be in the ISO format defined for xs:date in XML schema. Specifically, in the format YYYY-MM-DD. What format is your date data?
Sara, technical writer/jackbe
I was tring to create a Mashlet using an Excel service I have created, I wan to filter my data from a perticular date range , Here I am facing a problem when I am tring to use input action with date data type. It gives an Error like this "Error execution Mashup Script : Unable to parse the date"
can any one help me on this issue