User (Legacy) Posted June 11, 2003 Report Share Posted June 11, 2003 When I use the ToOADate VB.NET return values like: 126994968000000000 When I try to import an xml doc with these values and a column set to "Type=Date" then it returns an error: "String was not was not recognized as a valid DateTime" Here is the xml doc: <?xml version="1.0" ?> - <CHARTFX> - <COLUMNS> <COLUMN NAME="Date" TYPE="Date" /> <COLUMN NAME="PlayedMinutes" TYPE="Double" /> </COLUMNS> <ROW Date="126993240000000000" PlayedMinutes="43" /> <ROW Date="126994104000000000" PlayedMinutes="5270" /> <ROW Date="126994968000000000" PlayedMinutes="6538" /> <ROW Date="126995832000000000" PlayedMinutes="6060" /> <ROW Date="126996696000000000" PlayedMinutes="8343" /> <ROW Date="126997560000000000" PlayedMinutes="2" /> </CHARTFX> Link to comment Share on other sites More sharing options...
User (Legacy) Posted June 11, 2003 Author Report Share Posted June 11, 2003 I found a solution. Just used type=string for the first row "Michael Bodekaer" <michael@elope.dk> wrote in message news:yrCbPn$LDHA.2804@webserver1.softwarefx.com... > When I use the ToOADate VB.NET return values like: > > 126994968000000000 > > When I try to import an xml doc with these values and a column set to > "Type=Date" then it returns an error: "String was not was not recognized as > a valid DateTime" > > Here is the xml doc: > > > <?xml version="1.0" ?> > - <CHARTFX> > - <COLUMNS> > <COLUMN NAME="Date" TYPE="Date" /> > <COLUMN NAME="PlayedMinutes" TYPE="Double" /> > </COLUMNS> > <ROW Date="126993240000000000" PlayedMinutes="43" /> > <ROW Date="126994104000000000" PlayedMinutes="5270" /> > <ROW Date="126994968000000000" PlayedMinutes="6538" /> > <ROW Date="126995832000000000" PlayedMinutes="6060" /> > <ROW Date="126996696000000000" PlayedMinutes="8343" /> > <ROW Date="126997560000000000" PlayedMinutes="2" /> > </CHARTFX> > > > Link to comment Share on other sites More sharing options...
Software FX Posted June 11, 2003 Report Share Posted June 11, 2003 If you specify: <COLUMN NAME="Date" TYPE="Date" /> Then the data should be in a date format (using the Chart's current culture), for example: <ROW Date="6/11/2003" PlayedMinutes="43" /> -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.