Page 1 of 1

Serious Date Bug

Posted: Tue Mar 11, 2008 5:38 pm
by SparkGap
One of my instruments produces CSV data thus:-

Date,Time,Reading1,Reading2
29/2/2008,23:59:57,15,31
29/2/2008,23:59:58,15,30
29/2/2008,23:59:59,16,29
01/3/2008,00:00:00,17,28
01/3/2008,00:00:01,18,27
01/3/2008,00:00:02,19,26

Dplot cannot understand this date format and reverses the plot so that 01/03/2008 occurs before 29/02/2008

Rather than unsuccesfully trying to decide which date format is in use and changing it's mind half way though parsing, wouldn't Dplot benefit from a checkbox or dialog after loading the file?

Keep up the good work.
Regards, Martin

Posted: Wed Mar 12, 2008 10:07 am
by DPlotAdmin
Martin,
See "Assume dates are of the form d/m/y" under Options>General.

Posted: Wed Mar 12, 2008 11:14 am
by SparkGap
Ah,
I Couldn't see the wood for the trees.
Thankyou, works fine now.

Posted: Wed Mar 12, 2008 11:24 am
by DPlotAdmin
I Couldn't see the wood for the trees.
That's a problem in several places within DPlot that I'm continuously arguing with myself about. Options should be obvious, but on the other hand nobody wants 20 checkboxes on every single dialog box.

If you have any other problems please let me know.