the GetXML method of the DataSet returns date fields in the format:
2005-10-09T15:13:00.0000000+02:00
can this be changed?

TIA!!!

Hi,

You would have to be lucky that it is like this, it helps you to be able to
use in any culture.

You can use a string, from which I know that there are a few situations
where this can be done. However again, take care where you use this.

A date as 1-12-2005 given by somebody in another culture, can be meant what
is for you 12-1-2005. By instance if you have a program used in a Bank,
than you can probably understand what can be the result of this. The most
common used in the world are by the way yyyy-MM-dd hh:mm:ss and dd-MM-yyyy
hh:mm:ss.

(Also however very much less are used dd-MM-yyyy hh:mm:ss pm/am and
MM-dd-yyyy pm/am)

I hope this helps,

Cor

"z f" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> the GetXML method of the DataSet returns date fields in the format:
> 2005-10-09T15:13:00.0000000+02:00
> can this be changed?
>
> TIA!!!
>
>

this XML is transformed using XSL to HTML.
the problem is to change the format in XSL.
so if there is a flag to the DataSet in what format to output the date it
would be easier.
thanks.

"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> You would have to be lucky that it is like this, it helps you to be able
> to use in any culture.
>
> You can use a string, from which I know that there are a few situations
> where this can be done. However again, take care where you use this.
>
> A date as 1-12-2005 given by somebody in another culture, can be meant
> what is for you 12-1-2005. By instance if you have a program used in a
> Bank, than you can probably understand what can be the result of this. The
> most common used in the world are by the way yyyy-MM-dd hh:mm:ss and
> dd-MM-yyyy hh:mm:ss.
>
> (Also however very much less are used dd-MM-yyyy hh:mm:ss pm/am and
> MM-dd-yyyy pm/am)
>
> I hope this helps,
>
> Cor
>
> "z f" <(E-Mail Removed)> schreef in bericht
> news:(E-Mail Removed)...
>> the GetXML method of the DataSet returns date fields in the format:
>> 2005-10-09T15:13:00.0000000+02:00
>> can this be changed?
>>
>> TIA!!!
>>
>>
>
>

[dima77]

I read excelent how to solve this
http://gregnozik.blogspot.com/2011/0...od-enough.html