Time Issue When Transfering Data

[achouse]

I am trying to transfer data from LabView into Excel but when I do I am getting a value of 12/31/1905 8:00 PM for the time instead of the time elapsed since the start of the experiment.  I have changed the time manually in Excel and my data was correct.  I tried to change the time in the diagram window but it has yet to make a change in the Excel file that results. 

Amelia House

University of Delaware

[Phil_J1]

Hi Amelia,

Permit me to ask you a few questions to get some details:

1) Are you using SignalExpress, or LabVIEW?

2) How are you trying to send your data to Excel?

Thanks,

Phil

[achouse]

Hi Phil-

 I am using LabView.  So far, I have been trying to use the Export Waveforms to Spreadsheet File.vi. Hope that helps.

Amelia

[Phil_J1]

Yes, that was very helpful.

When writing out data to file, "Export Waveforms to Spreadsheet File.vi" uses the waveform's t0 to calculate what time to write out in the file. In LabVIEW, most (non-hardware generated) signals have a t0 of zero (which translates to 12/31/1903 18:00). To fix this, you could use "Get Date/Time In Seconds" in the LabVIEW palette to get the current time, and overwrite your waveform's t0 using "Build Waveform".

I hope this makes sense. If that isn't it, feel free to attach your top-level VI to take a look at it.

Phil

[achouse]

Hm, that does not seem to be working.  Here is the file for you to look at and maybe find some answers.

Amelia

[Phil_J1]

Ok, so the reason that you are getting the type of t0 that I was mentioning is because the subVIs that you are calling to get data from your TDS1k/2k returns an artificial timestamp since the hardware doesn't seem to return any.

The image i'm including is what I was trying to say.

If that is still no good, you may want to post an additional message either on the LabVIEW forum or a hardware forum, given that this is the SignalExpress forum. On that note, there is a SignalExpress Tektronix Edition which will work with a TDS1k/2k and easily export data to Excel.

I hope that was still a little helpful.

Phil

[anita_tck]

I have others problem. I send date data, format dd/mm/yyyy from NI v8.0 to Microsoft excel... The data is success display but sometimes the format had change into mm/dd/yyyy. How to set display date into excel???.

[Elizabeth_K.]

anita_tck:

To change the display format in Excel, highlight the cells you want to change, right-click, and select "Format Cells." Under Category, select Date, and in locale, make sure to select English (United Kingdom).  This should give you the option to select the dd/mm/yyyy format to display the date.

Elizabeth K. 

National Instruments | Applications Engineer | www.ni.com/support 

[anita_tck]

i know about this setting, but what my client wants,date pass from NI (dd/mm/yyyy) and display auto in excel using format dd/mm/yyyy.. the problem now, only day between 1-12th will be change and display in format mm/dd/yyyy in excel.the others day are display right...