Time stamp not recognized by Excel

[smercurio_fc]

Which constant are you referring to? The 126298800 value? If so, then yes, you would need to change it since you hard-coded the subtraction of 5 hours, which is your offset from GMT. In Japan your offset would be different.

[gasseous]

Yes, that is the constant I am talking about. Is there another way to do this so I don't have to change it?

[Brinoceros]

Hi gasseous,

You could read the time zone from Windows, then use an appropriate offset.

Cheers,

[TCPlomp]

LabVIEW can directly return the offset from UTC with the specifier <%z>

Ton

[gasseous]

Ton,

Thank you for this information. I shall try it and see how it goes. I assume that this means I can do away with the adding and dividing of constants?

[smercurio_fc]

The "adding and dividing" of constants has nothing to do with the offset from UTC. As I explained here, it has to do with the fact that LabVIEW measures time from a different starting point that OLE dates. Also, OLE date are in terms of days, but LabVIEW is in terms of seconds. The offset from UTC simply changes the value of the constant, not its need to be there.