Campbell Scientific RTDAQ Software - Manual (Page 317)

Section 10. Utilities
If processing a table-based data file, use a 1 for all time elements (assuming the
time stamp is the first element in the data file). For the examples above:
date("mm/dd/yy, h:nn";1;1;1;1) "02/25/02, 4:10"
edate("mm/dd/yy, hh:nn";1;1;1;1) 02/25/02, 04:10
edate(“yyyy”, “dayofyear”, “hhnn”;1;1;1;1) 2002, 56, 0410
Notice that this last example essentially creates an array-type of timestamp.
When processing a data file from a mixed array datalogger, if the
time stamp uses midnight as 2400 with "today's" date, the date
function will convert that time stamp to 0000 hours with
"tomorrow's" date. The “No Date Advance” function can be
used to stop the date from rolling forward (Other button, No
Date Advance check box). NOTE
edate("format"; S; H; D; Y) edate( ) functions identically to date( )
above, except that the time stamp is not surrounded by
quotes.
Monthly Summary Example
The Date function can be used to produce a monthly summary of daily time
series data by using Date( ) for the interval in the time series function. This
will trigger time series output for the first day of each month. The syntax is
avg(7;date(3;2)), where you want to take a monthly average of element 7, and
the day of year is contained in element 3 and the year in element 2. If you
have data recorded on a once per minute or once per hour basis, it must first be
processed into a 24 hour summary for this function to produce the output
expected.
When Date and Edate are used within other functions they must
be used with the older format Date(doy;y) and Edate(doy;y)
instead of using the extended date functions. For example
AVG(1;Date(3;2)). When used with table based data files the
format would be AVG(1;Date(1;1)). NOTE
When producing a monthly summary and outputting the month along with the
data, you might want to set up the value for the month as "month -1", to
correctly reflect the month that the data actually represents.
10.3.3.1.13 Split Functions Example
The following is a parameter file that operates on the Mt. Logan data with
several of the Split features being utilized. This first screen shows the input
file and the select criteria that were programmed. This example does
calculations based on temperature and wind speed to determine the wind chill.
10-47