Valid Date Formats for Presto Mashables and Mashups
The information source providers for mashables determine what is valid input for the web services or feeds that they provide, including the date and time formats that they support. In most cases in Presto, the fields where you enter dates allow you to control the exact format of the date. You must provide dates and times in the expected format for that information source.
WSDL web services, however, commonly use the ISO 8601 date standard and specifies this in the WSDL. If this is set in the WSDL, Presto provides a window where you can select a date, and if appropriate a time, and automatically formats your choice to meet this standard.
For mashups and database mashables, however, Presto is the information provider. The date and time formats that you can use in input parameters to mashups or database mashables include:
Supported Date Format | Notes/Examples |
YYYY/MM/DDThh:mm:ss.sss (ISO 8601) | Time is based on a 24-hour clock (0-23). For example:  1950/06/01 00:01 2008-10-31 1999.12.31 23:59:59 |
YYYY/MM/DD hh:mm:ss.sss |
YYYY-MM-DD hh:mm:ss.sss |
YYYY.MM.DD hh:mm:ss.sss |
YYYY/MM/DD hh:mm:ss |
YYYY-MM-DD hh:mm:ss |
YYYY.MM.DD hh:mm:ss |
YYYY/MM/DD hh:mm |
YYYY-MM-DD hh:mm |
YYYY.MM.DD hh:mm |
YYYY/MM/DD |
YYYY-MM-DD |
YYYY.MM.DD |
