Can access a files time stamp for calculations?

[JeffGrimes]

I'm using Diadem 10.2.  We have an issue with our data, where the first cycle is corrupt iff the time stamp between the current file and previous file is less than 30 minutes.  This indicates a manual intervention, and it results in skewed results.

I want to discard the first cycle when the File time stamps are less than 30 minutes apart...but I can't find a way do it.

We use runtime in the file as a time channel, begins at zero each file, so i can't use any channel values to do this?

Thanks in advance for the help.  Completing this task will end my assignment with this team, and I'll be moving to a new position at the end of the week.  Not sure if Diadem is in my future or not, but I highly doubt it.

Thanks in advance...

[JeffGrimes]

Alright...I guess File Date stamp and File Time Stamp aren't sufficient search words...nothing comes up in Diadem Help.  Go figure.

One of the engineers mention creation date vs. modified ...I searched and found FileDateGet.

So, now I have the info I need, just need to do the math.

Cheers.

[Brad_Turpin]

Hi Jeff,

What type of data files are these?  If it's a custom file format, did you write the DataPlugin that reads the file into DIAdem?  Is the aquired date/time stored inside the data file somewhere?  For a TDM or TDMS file, this would typically be in the "File.DateTime" property, which shows up in the DataFinder as "File.Storage datetime" and in the Data Portal as "File.Storage date/time".

The File created and modifed dates you get from Windows tend to change unexpectedly, so it would not be ideal to use those for a mission-critical process.

I'm assuming that you're loading all the various data files into DIAdem, then concatenating them into contiguous channels that contain all the data from all the files.  You will then need to use e "Calculate Differences" ANALYSIS function to create a new channel that has the delta date/time values for each row. Once this is the case, you can use the Channel Calculator to find rows where the delta date/time value is invalid and set these rows equal to NoValues.

Brad Turpin

DIAdem Product Support Engineer
National Instruments