I have some files generated by a SCADA Software, and I want to read the DateTime from it.
It is in Windows: 64 Bit Hex Value - Little Endian
Ex.: 40CA582BD984CB01 = 2010-11-15 15:24:18 UTC
In VB.Net I use a Int64 variable to read from the file and then convert to DateTime as ticks, adding 1600 years, but I want to read it in Access.
Does anyone knows how to do this?
I try to read in 2 Long (4 byte) var and multiply them into a double, but cannot convert into date.
Note: the last byte is always '01'
It is in Windows: 64 Bit Hex Value - Little Endian
Ex.: 40CA582BD984CB01 = 2010-11-15 15:24:18 UTC
In VB.Net I use a Int64 variable to read from the file and then convert to DateTime as ticks, adding 1600 years, but I want to read it in Access.
Does anyone knows how to do this?
I try to read in 2 Long (4 byte) var and multiply them into a double, but cannot convert into date.
Note: the last byte is always '01'
