Re: Date converting

Frank

>where I can found GetDateFromXML ?

There is no function called that, it's an example
    - you'd need to extract the date from your XML file/field with
whatever your using to read/parse the XML file.

All I was showing is that by changing the date formats you can read it in
using one format change the format and write 
it out in another.

After reading your first post again I see that your actual data in the
file looks like

    <date value="1208194275921" />

then what I showed isn't what you want.

The date is probably UTC or GMT format (no. seconds since sometime in the
past) which has Date and Time components.

There are functions available to convert the data from that number into a
datetime value.
A search of MSDN points to -
http://msdn2.microsoft.com/en-us/library/5hh873ya.aspx
which should get
you started.

-- 
CYA
Steve