how concatenate date and array to write in excel?

[behzad1]

Hello

I have a problem to concatenate a date array and numeric array. can you help me?

I want save Measurement of a sensor with save time in an excel (row 1 column1 save date and row 1 coulmn : save sensor data). but I cant save these two value seperatly(my clocks cant do it). now, I want concatenate them at first and then save them. is it possible?

Best Regards

[Zwired1 · Accepted solution]

Try the attached.  You'll understand it as soon as you see it.  If not, shout.

[behzad1]

thank you Zwired1

your respons, really helped me.

just a problem is that, when I save data in the excel file, and read that a agein,  my date change to unkown number. for example: 11/10/2014 change to 41953! in labview. do you know why this happen?

Best regards

[Vij@y]

Hi benzah1,

Attach your vi. It will be more helpful to solve the problem.

[Rod42]

Hello,

The date showing as a number is an Excel display format problem.

41953 is the Excel number representing 10 Nov 2014.

In Excel you need to....

Select the cells containing the date

Format -> Cells -> Number -> Date

 EDIT: This fix changes how the date looks when displayed in Excel. I am now not sure if your problem was when you display the result in Excel or after reading the Excel file back into LabVIEW.

Rod

[behzad1]

Thank you Rod

in excel, show correct date. my problem is when I display the result in labview again.

.....................

Hello Vij@y

which code is need? i just read a date saved in excel. and format is problem.

Best Regards

[Vij@y]

Hi Behzad1,

Attach the excel file and the code (after reading the Excel file back into LabVIEW).