Subject:Format date fields Author:Cynthia van Boven Date:10 Jan 2009 03:55 PM
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.