PC Review


Reply
Thread Tools Rate Thread

Date format in an XML export

 
 
=?Utf-8?B?QmlsbA==?=
Guest
Posts: n/a
 
      22nd Apr 2007
Hi - I have an Excel 07 spreadsheet mapped so that certain columns export
their values in XML for use with some Flash charting components. The issue
I'm having is that my Date column is exporting using the universally valid
date calculation - you know the 5 digit date in the 30 thousands? This is all
well and good, except the chart component has no translation capability. It
just displays 39118, 39119, etc. It works if I type in "That there is Joon
thirty-first" but if it sniffs out that I'm doing a date of any type, it
reverts to this 5-digit calculation. It tells me that the dates are not valid
XML, and converts them, but I just want them to carry forward as a text value
into the XML transform.

Any ideas? I've already tried format-special, but it's during the XML export
that this all goes wrong.

Thanks

Bill
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Keep Date Format on Export? =?Utf-8?B?YWRuYQ==?= Microsoft Access 6 2nd Oct 2006 04:59 PM
Date Format Changes during export =?Utf-8?B?TGFuZHl3ZWRuYWs=?= Microsoft Access 3 15th Aug 2006 04:35 AM
Date format in XML export vjohnson@uh.org Microsoft Access Forms 1 22nd May 2006 06:59 PM
Export Date Format =?Utf-8?B?TXIuIEM=?= Microsoft Excel Programming 2 12th Jan 2006 08:59 PM
Export Outlook date field as date/time format to Access database =?Utf-8?B?QmVja3k=?= Microsoft Outlook Discussion 0 2nd Dec 2004 02:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:17 PM.