MashZone NextGen 10.2 | Appendix | Legacy Presto components | Mashables and Mashups | Mashups in EMML | Advanced Mashup Techniques | Converting and Working with Dates and Times
 
Converting and Working with Dates and Times
 
Using the ISODateFormatExt Custom XPath Function
ISODateFormatExt(dateText, fromFormat, toFormat)
Mashable or mashup results frequently contain date or time data in various string formats. Sorting, filtering or performing calculations requires converting the string representations of the dates or times to an acceptable format for XPath, which uses XML Schema datatypes. These are based on ISO 8601 formats:
yyyy-MM-ddThh:mm:ss.s zzzzzz
For details, see XML Schema Part 2: Datatypes.
In most cases, you can use the MashZone NextGen custom XPath function ISODateFormatExt to convert dates or times to a string in the ISO format. Then use an XPath datatype function to cast the string to a date or time.
Note: If your mashup script puts dates or times in variables, use the datetime datatype for the variable. The datetime datatype provides more reliable behavior than the date datatype which has been deprecated.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release