I never noticed this before :confused: . Just took a look now and it seems as though the dates export fine from the table view but when exported from a summary they come out preceeded by a '.
You can still pivot by this in excel it just doesn't sort them as a date it sorts them as a text field.
Is this the same problem you are encountering?
Not sure that this is an oversight as such, though I can understand how frustrating it can be.
Have a look at [url="http://www.datawatch.com/vortexmlsupport/monarch_faq.htm#33"]www.datawatch.com/vortexmlsupport/monarch_faq.htm#33[/url] from the general FAQ section on the Datawatch web site. The automatic link does not seem to get to the right section. Paste the URL in to your browser and it should give you the section I wanted to reference at the top of the page. The FAQ is
"When I export from the Summary Window, my numeric fields no longer hold a numeric data type."
Is there no solution available through the use of calculated fields to "re-format" the dates (ccyymmdd or Julian perhaps) or simply establish a value for which month/quarter, etc. and summarise by that? Ideas off the top of my head with no investigation done so far so my apologies if they seem irrelevant or ridiculous ...
Stephen you are correct in that you have identified the problem. I have been using the summary, now I have to export from the data sheet in order for the dates to be grouped in excel pivot tables in yr qtr and month. Wish they could fix this little oversite. Thanks for the response. Ron Jones /b[/quote]
[size="1"][ July 03, 2003, 05:01 PM: Message edited by: Grant Perkins ][/size]