Hello,
i have a smartphone application that generates a XML file. this file contains a text field, a numeric field and a date field. i would like to link this file to an Excel. i have done this without any problem. however, i have a weird date field. in fact it is 18 characters long. when i went back to the xml, here's what i found
<?xml version="1.0" encoding="windows-1252" standalone="yes" ?>
- <Expenses>
- <Expense>
<ExpenseType>Breakfast</ExpenseType>
<Amount>15.00</Amount>
<Description>Breakfast</Description>
<Date>632514320070000000</Date>
<Currency>USD</Currency>
</Expense>
</Expenses>
i thought that this is related to the encoding used (windows-1252) instead of UTF-8
do you know how i can convert from the encoding scheme to the second one so that i get a readable date in Excel.
Thanks a lot
Adnane
Micorosft North Africa
i have a smartphone application that generates a XML file. this file contains a text field, a numeric field and a date field. i would like to link this file to an Excel. i have done this without any problem. however, i have a weird date field. in fact it is 18 characters long. when i went back to the xml, here's what i found
<?xml version="1.0" encoding="windows-1252" standalone="yes" ?>
- <Expenses>
- <Expense>
<ExpenseType>Breakfast</ExpenseType>
<Amount>15.00</Amount>
<Description>Breakfast</Description>
<Date>632514320070000000</Date>
<Currency>USD</Currency>
</Expense>
</Expenses>
i thought that this is related to the encoding used (windows-1252) instead of UTF-8
do you know how i can convert from the encoding scheme to the second one so that i get a readable date in Excel.
Thanks a lot
Adnane
Micorosft North Africa