PLX-DAQ TIME and DATE at the same time issue

twoskinsoneman · 2020-07-29 23:22

Serial.println("DATA,DATE,TIME,");           
}

Using an Arduino Uno.
I am having issues with the second value after the directive DATA.
Using the code above the output into my spread sheet is Column A: 7/29/2020 Column B: 0.79
If I swap them so TIME is the first value and DATE the second I get Column A: 7:11:19 PM Column B: 44041.00

If I delete either the DATE or the TIME all the rest works fine.
Here's the other relevant code in case I am unknowingly causing the problem somewhere else.

Serial.begin(9600);
  Serial.println("CLEARDATA");
  Serial.println("LABEL,Date,Time,House,Shed,PUMP STATUS,PUMP CYCLES");
  Serial.println("RESETTIMER"); 

Serial.print("DATA,DATE,TIME,"); 
          Serial.print(HouseOutputValue);
          Serial.print(","); 
          Serial.print(ShedOutputValue); 
          Serial.print(","); 
              if(PumpStatus == HIGH){
            Serial.print("ON");
              }else{
            Serial.print("OFF");}
          Serial.print(","); 
          Serial.println(PumpCycles);

Thanks for any help. I realize this an old unsupported software.

Publison · 2020-07-29 23:55

Did you try the new version?

https://www.parallax.com/downloads/plx-daq

twoskinsoneman · 2020-07-30 22:40

I switched to the new version. Thanks.
The problem was a simple column format issue.

PLX-DAQ TIME and DATE at the same time issue

Comments