LabPlot date import format

[Bill Gee]

Hello everyone -

Fedora 33, LabPlot 2.7.0

I have now collected the year's worth of data that I want to start plotting.  In my first run I am finding that the date format is coming out all wrong, and I cannot figure out how to set it right.  The attached file is a PDF showing how the graph comes out.

The exported data looks like this.  I include only a few rows.  The entire file is 17569 rows, which is one header row and then a row for every 30 minutes for a year.  The date format is month/day/year and the time format is hour:minute:second.  I am trying to graph temperature against time.  And yes, the temperature line will be dang near flat.  don't worry about the Abs Press column for now.

Date Time,Abs Pres,Temp
01/01/2020 00:00:00,14.3228,56.923
01/01/2020 00:30:00,14.3184,56.923
01/01/2020 01:00:00,14.3110,56.923
01/01/2020 01:30:00,14.3110,56.923
01/01/2020 02:00:00,14.3065,56.923
01/01/2020 02:30:00,14.3006,56.923
01/01/2020 03:00:00,14.2946,56.923
01/01/2020 03:30:00,14.2962,56.923
01/01/2020 04:00:00,14.2946,56.923
01/01/2020 04:30:00,14.2872,56.923
01/01/2020 05:00:00,14.2829,56.923
01/01/2020 05:30:00,14.2784,56.923
01/01/2020 06:00:00,14.2784,56.923
01/01/2020 06:30:00,14.2739,56.923
01/01/2020 07:00:00,14.2755,56.923
01/01/2020 07:30:00,14.2724,56.923
01/01/2020 08:00:00,14.2724,56.923
01/01/2020 08:30:00,14.2755,56.923
01/01/2020 09:00:00,14.2724,56.923
01/01/2020 09:30:00,14.2710,56.923
01/01/2020 10:00:00,14.2636,56.923
01/01/2020 10:30:00,14.2591,56.923
01/01/2020 11:00:00,14.2547,56.923
01/01/2020 11:30:00,14.2400,56.923
01/01/2020 12:00:00,14.2252,56.923
01/01/2020 12:30:00,14.2118,56.923
01/01/2020 13:00:00,14.2014,56.923

I create a project, then add a spreadsheet to the project.  Then I import to the spreadsheet from the CSV file.  In the import screen I specify the date format as "MM/dd/yyyy mm:hh:ss".  LabPlot seems to completely ignore the format I give it, as evidenced by the dates on the graph.  I also try changing the format in the definition of the x-axis, but it has no apparent effect.  The drop-down boxes for both screens does not contain a date format that will work.

Is there a way to tell LabPlot what the format of the date string is?

Thanks!

-- 
Bill Gee

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kde-edu/attachments/20210111/383e1765/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: TestGraph.pdf
Type: application/pdf
Size: 49434 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/kde-edu/attachments/20210111/383e1765/attachment-0001.pdf>