convert date to time stamp

[slipstick]

I am opening an Excel sheet and extracting serial numbers and dates from it. The dates are coming in as a decimal number which is not converting into a time stamp I can use. A picture of my vi is attached. The yellow note on the front panel is the date in Excel that that number represents.

How do I fix this to be a time stamp?

Tay

[slipstick]

Never mind - it's an Excel cell formatting issue. Excel is displaying that number as a date. LabVIEW pulls in the number. So I guess I'll be saving the original Excel file as a tab delimited text file as well, so I can use the date function.

Tay

[Dennis_Knutson]

If you had searched the forum for 'excel date', you would have found a lot of references. This is one.

[slipstick]

Yeah, I didn't think to search the LabVIEW forum for an Excel idiocy.

Tay