date types in xml datasource

[2005 IR Help]

By: cablehead - cablehead

date types in xml datasource

2005-08-05 03:16

I'm trying to set the field type to java.util.Date for some date fields I have in a xml datasource, but can't get it to work.

 

Setting the field type to java.lang.Float or java.lang.Integer for numeric values in my data source works great.

 

The date field is in the format yyyy-MM-dd in the xml file:

 

<preparationDate type="xs:date">2005-08-25</preparationDate>

 

I've tried with and without the type="xs:date" declaration.

 

Loading the field as a string and then creating a variable with the expression:

 

new SimpleDateFormat("yyyy-MM-dd").parse($F{preparationDate})

 

works just fine.

 

Is it possible to set the field type to date for date values in xml datasources?

 

Any help is greatly appreciated,

Andy.