<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;"><span style="font-size:0.92em;">Hello everyone -</span></p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Fedora 33, LabPlot 2.7.0</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right: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.</p>
<p> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">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.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Date Time,Abs Pres,Temp</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 00:00:00,14.3228,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 00:30:00,14.3184,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 01:00:00,14.3110,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 01:30:00,14.3110,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 02:00:00,14.3065,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 02:30:00,14.3006,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 03:00:00,14.2946,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 03:30:00,14.2962,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 04:00:00,14.2946,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 04:30:00,14.2872,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 05:00:00,14.2829,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 05:30:00,14.2784,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 06:00:00,14.2784,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 06:30:00,14.2739,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 07:00:00,14.2755,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 07:30:00,14.2724,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 08:00:00,14.2724,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 08:30:00,14.2755,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 09:00:00,14.2724,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 09:30:00,14.2710,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 10:00:00,14.2636,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 10:30:00,14.2591,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 11:00:00,14.2547,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 11:30:00,14.2400,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 12:00:00,14.2252,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 12:30:00,14.2118,56.923</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">01/01/2020 13:00:00,14.2014,56.923</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">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.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Is there a way to tell LabPlot what the format of the date string is?</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Thanks!</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;"><br />-- </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Bill Gee</p>
<br /><br /></body>
</html>