timestamp date

[faustina]

I have a 3rd-party card that I use to collect data.  The data is imbedded with an IRIG timestamp.  I'm able to extract the timestamp data and display it correctly in LabVIEW. (see enclosed VI).  The data is saved in a .csv file.  In DIAdem, I read the file, then using the 2 channels containing time data I create a timestamp (time format) channel using the Calculator.  I seem to be computing the time portion just fine, but not the date portion.  Below is the formula in the calculator:

Ch("[1]/timestamp) = Ch("[1]/seconds) + 2082844800 + Ch("[1]/subseconds)*1.0E-6

What am I missing?

[Brad_Turpin]

Hi faustina,

If your CSV file that you're reading into DIAdem shows seconds since 1970, then the offset you want to add is 62167132800.  In that case I would recommend you build that conversion into the DataPlugin you use to read the CSV file into DIAdem.

If the CSV file was written by LabVIEW and stores seconds since 1904, the the offset you want to add is 60084288000.  In that case I'd recommend exporting to TDMS file instead.

Brad Turpin

DIAdem Product Support Egineer

National Instruments

[faustina · Accepted solution]

The data files (although collected with LabVIEW) are processed with another application.  It's the output of that application (.csv) that needs to be read in DIAdem.  The 62167132800 value works.