excel time string

[WeberM]

Hello,

i've got a problem with an Excel import. One cell is a date like 07.2.2008.

LV reads it a string array with 39485 for the date.

Is it possible to transform it back to the date?

Markus

[GerdW]

Hi John,

Excel stores dates (usually) as number of days since 01.01.1900 - hence 39485 is 07.02.2008.
You can do two things:
1) switch excel to use the 01.01.1904 as start date (like LabView does)
2) subtract the offset of 4 years (number of days=1462) from the Excel date number (39485-1462)

Then you have to multiply the resulting number by 86400 (seconds per day), this can be wired to the LabView time functions...


Message Edited by GerdW on 02-18-2008 12:59 PM

[hurban]

Hi GerdW

as always the real good answers can be found in the LabView discussion forum - thanks a lot !

regards HU