Ben,

Thanks for your suggestion. I may try that for a bit of fun when I get a quiet moment.

Claire

Frank,

Thanks for the link to the atricle.

I did see the article earlier, but did not want to use xml.

After tearing my hair out (as I know I did it...

That worked a treat!

Thank you so much for your help.

Claire

Once again, thanks very much for your help.

Have just picked up your suggestion - shall give it a try on Monday and let you know if it has done the...

What is the format of date returned from database if you use your account?

yyyy-mm-dd hh:mm:ss:ms

e.g. 2008-03-04 10:44:54.000

How do you convert it to requested format?

cast(convert(varchar, createddate, 103) as datetime)

returns: 2008-03-04...

Thanks for the speedy reply.

I forgot to mention in my post that I have looked at that too.

Any other ideas?

Thanks