Changing time to milliseconds

[svazquez22]

Hello all, I have a VI that records signal data and writes it to a file. As it currently stands, the time column displays in a date and time format, is there a way to get the time column to be recorded in milliseconds instead? Thank you.

[GerdW]

Hi svazquez,

---

@svazquez22 wrote:

I have a VI that records signal data and writes it to a file. As it currently stands, the time column displays in a date and time format,

---

This is because you use an ExpressVI to save your data: they are easy to use and limited in their options…

Suggestion:

Read the samples as an array of waveforms and save the waveforms. So you get the t0/dtinformation for free!

[svazquez22]

It seems like changing the DAQmx read to 1D Wfm displays the timing properly on the graph. I tried using the Export Waveforms To Spreadsheet file block and ran into issues with the column formatting, also the timing appears to still be exported as a date and time. I have included my vi and a screenshot of the data output.

[GerdW]

Hi svazquez,

---

@svazquez22 wrote:

the timing appears to still be exported as a date and time. I have included my vi and a screenshot of the data output.

---

Thanks for VI and screenshots…

See these suggestions:

Here you see two ways of creating an array of relative timestamps from measurement data. (The orange wire in the lower example comes from the sample rate constant…)

[svazquez22]

Ok thank you, but my excel file is still formatting everything into one column, how do I prevent that from happening? Also I want to note I am trying to write to a .csv file.

[svazquez22]

You can ignore my last post as I figured out how to separate the data into separate columns, but again, the time is not displaying how I would like in my file. Once again, I have included a screenshot and my vi, sorry if the last thing you posted explains how to fix my time display issue.

[GerdW · Accepted solution]

Hi svazquez,

---

@svazquez22 wrote:

sorry if the last thing you posted explains how to fix my time display issue.

---

Next suggestion:

[svazquez22]

I'm assuming the idea is to create a new time column and then write it into a new spreadsheet. However, when I tried using your method I got an error. I did some searching online and it might have to do with the fact I am taking a finite number of samples.

[GerdW]

Hi svazquez,

---

@svazquez22 wrote:

I did some searching online and it might have to do with the fact I am taking a finite number of samples.

---

The error comes because you are trying to read the samples TWICE from your task. Why do you do this?

Read once, format the data as you need and write once to a file…

[svazquez22]

Ok I believe that the time is displaying how I would like it now, but my data is now being written incorrectly. I would like the data separated by columns and not rows. Like I had in previous results I got. I have included a screenshot of what I have and of my desired format. I appreciate all of your help up to now!