cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Converting formatted excel date to useful data in labview

Converting formatted excel date to useful data in labview

I am using the report generation toolkit for Office, and reading an excel file.  All the data comes back fine, except for the date column.  In excel the column is formatted as a date (ex. 5/5/05) but when it comes through in labview it ends up being something like "37740", it's the same effect if you switch the format in excel to general, the date changes to a number.  Is there anyway to leave the formatting the way it is in Excel and still bring into labview a useful date, or would I have to format the excel file differently?
 
Thanks.
0 Kudos
Message 1 of 3
(690 Views)
Highlighted

Re: Converting formatted excel date to useful data in labview

I think I have it figured out using the Excel serial number date.  I attached a vi of something I threw together quickly to convert excel date serial numbers to labview date info.  I'm not 100% if it works all the time, but the few examples I tried worked fine.
0 Kudos
Message 2 of 3
(685 Views)

Re: Converting formatted excel date to useful data in labview

You can take a look at the tools posted on LAVA Forum by jbrohan. I didn't try them myself. Usual disclaimer.


LabVIEW, C'est LabVIEW

0 Kudos
Message 3 of 3
(680 Views)