Serious Date Bug

SparkGap · Post by **SparkGap** » Tue Mar 11, 2008 5:38 pm

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

Post by **DPlotAdmin** » Wed Mar 12, 2008 10:07 am

Martin,
See "Assume dates are of the form d/m/y" under Options>General.

SparkGap · Post by **SparkGap** » Wed Mar 12, 2008 11:14 am

Ah,
I Couldn't see the wood for the trees.
Thankyou, works fine now.

Post by **DPlotAdmin** » Wed Mar 12, 2008 11:24 am

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.