Sorry my mistake.

There isn't anyone I can ask really.

Thanks Alot for the help,works like a dream.

Apologies for the misunderstanding,

Thank you :hehe:

Thanks for the reply,

Problem is that I have hundreds of rows of data and I cant type every row in.Also the rows aren't only 1.1, there is also 1.2, 1.2.1,...

Problem has been sorted out.

The problem is an Xml problem. When converting to XMldata document, the date gets adjusted. I used the following code to sort out the problem.

After declaring...

Almost works.

When I convert using VarChar:

select CONVERT (varchar(11) ,WbsStartDate,126) from wbsdata

the result is May 25 2006 which is almost ok.

I need the format to be 2006 May 25. I...

I am reading the data in a dataset and then converting to XML or

I have tried that, but my XML result is still:

2006-05-25T00:00:00+02:00.

I have tried that, but my XML result is still:

2006-05-25T00:00:00+02:00.