XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Cynthia van BovenSubject: Format date fields
Author: Cynthia van Boven
Date: 10 Jan 2009 03:55 PM
Dear LS,

When converting csv files to xml and then via xsl to a destination xml file I often experience problems with date fields not being in the correct notation for the receiving application. The expected date format is yyyy-mm-dd.

What's the best way to put those fields in the correct notation? Should I do it by changing the international settings of Excel? Seems not the nicest solution as you then have to revert it a lot of times to work with normal European notation in between xml stuff.

A better solution seemed to be to specify a target data type in Stylus Studio for which an option is available in the csv to xml adapter (property: target data type). I tested this but it didn't work and this is also what the manual states: cuurently not supported.

Hope you can help,



Cynthia

Postnext
Tony LavinioSubject: Format date fields
Author: Tony Lavinio
Date: 13 Jan 2009 09:56 AM
Actually, you want to set the source data type to Date, and then
set the 'date order' property to whatever is in your input file.

The converter will then emit YYYY-MM-DD dates.

Posttop
Cynthia van BovenSubject: Format date fields
Author: Cynthia van Boven
Date: 13 Jan 2009 03:18 PM
Thanks that helped!

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.