How to add timestamp into the beginning of DBL array?

[nhan91213]

Hi..

Does anyone know how to add timestamp into the beginning of DBL array?

I've tried using Get Date/Time in strings and spreadsheet string to array since i know that the elements of the array must be all of the same type..

But lastly, it didn't write the timestamp in full format and only have 1 reading..

I've attached the image of my vi(after i add get date/time) and the result in the excel..

FYI, I am going to save the data in TDMS file and usinf TDMS write..

TQ..

TQ..

[crossrulz]

First of all, don't use Spreadsheet String To Array.  Just use the String To Floating Number function.  Then use Initialize Array with those values.  Set the size to match one of the other arrays.

[Dennis_Knutson]

You could also build an array of waveform data types. A for loop with the build waveform function would work.

[RTSLVU]

Well you can and you cant...

Use something like this:

Feed it into your build array and you will have a DBL that is equivelent to the number of seconds elapsed since 12:00 a.m., Friday, January 1, 1904 (LabView  Time Stamp)

If you want a DBL that can be directly formatted to an OLE time stamp in Excel or any standard speradsheet program then you need to do some conversions first.

[nhan91213]

I also tried connecting 'Get date/time" with "Fract/exp string to number"  then connect the dbl to the initialize array to set the dimension for the array..(pic)

But,the result still show the same as previous..

[Dennis_Knutson]

What you are doing does not make much sense. You won't get a proper timestamp for tdms that way.

[nhan91213]

---

@Dennis_Knutson wrote:
What you are doing does not make much sense. You won't get a proper timestamp for tdms that way.

---

What should I do then?could you please show me how to build an array of waveform data types as per you told early?I have no idea at all...

[Dennis_Knutson]

Use the build waveform function on each of the 1D arrays.