convert LabVIEW timestamp to DIAdem timestamp with high precision

[faustina]

I'm know LabVIEW but not DIAdem and have never done scripting in DIAdem.  I collected data in LabVIEW and wrote the channels in waveform format to TDMS files.  In DIAdem I want to examime the timestamps with the same precision as my sampling rate; dt=1.0E-6.  I've discovered that DIAdem has limited time precision http://digital.ni.com/public.nsf/allkb/535EA75FF4D32411862575EE007663B4 and it has been suggested that the timestamp be converted to DBL in LabVIEW and then read in DIAdem.  So I wrote a VI that converts the waveform data in my original TDMS file to Y-values and DBL numeric timestamp and puts it in a new TDMS file.  (see enclose VI)

I've looked at:

http://www.ni.com/example/30230/en/

http://digital.ni.com/public.nsf/allkb/90E9D446A041976586256C84006E4E83

http://forums.ni.com/t5/DIAdem/Getting-correct-Date-Time-data-in-DIAdem-11-from-LabView-tdms/m-p/988...

http://forums.ni.com/t5/DIAdem/Import-time-channel-into-DIadem-from-a-tdms-file/td-p/806694/highligh...

and still don't understand how to convert my numeric timestamp to a #mm.dd.yy hh:nn:ss:ffffffff format in DIAdem.  What am I missing?‎

[Brad_Turpin]

1Hi faustina,

There's no way in DIAdem 2015 or previous versions to display datetime information with greater accuracy than 0.1ms.  You can plot the data vs. datetime, but all the data points from 0.050ms to 0.149ms within the same hour:minute:second will be plotted in a vertical line at datetime = 0.100ms.  If you choose to plot vs. relative (elapsed) time, displaying as a numeric value of seconds, then the only restriction is the resolution of the DBL data type, which is significantly better than 0.001ms.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[faustina]

okay, is there a way to extract components of a timestamp in DIAdem? I noticed a VBS method DataPart.  Can this apply to timestamp channels?  Is it something that can be called from the Calculator or do I need to write a script?

[Brad_Turpin]

Hi faustina,

If you're using the Calculator, then I'd suggest using the RTP() function.

Brad Turpin

DIAdem Product Support Engineer

National Instruments