Campbell Scientific LoggerNet Datalogger Support Software - Manual (Page 365)

Section 8. Working with Data Files on the PC
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).
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)).
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.
NOTE
NOTE
8-67