Info360 provides a library of tools to access the date and time values of time series data.
Syntax
Each of the Date and Time functions use the same simple format:
Function([Sensor ID]) - outputs the date and time of each time series point in the format specified by the function.
Function | Output |
|---|---|
Date | Returns the date and time of each measured value as a data type of "DateTime". Because of the data type, this output cannot be plotted on a graph as a reference chart. |
Day | Returns the current day of the month. For example, if the current date is December 19th, the function will output the value 19. The following example shows data output for day 16.
|
DayOfWeek | Returns the day of the week as an integer with Sunday starting as 0. For example, Sunday is "0", Wednesday is "3", and Saturday is "6". The following example shows the DayOfWeek values as integers which climb from 0 to 6 and back again as each week changes.
|
Hour | Returns the hour of the day in military time. For example, 8:45 am outputs "8", while 8:45 pm outputs "20". The following example shows fifteen minute time series data with Hour() and Minute() functions. The Hour output goes from 23 to 0 as the day switches. The Hour values remain the same throughout the hour, so 1:30 still outputs a value of 1.
|
Minute | Returns the minute of the hour. For example, 8:45 am outputs "45". The following example shows fifteen minute time series data with Hour() and Minute() functions. The Minute output shows 0, 15, 30, and 45 in a repeating sequence each hour.  |
| Month | Returns the month of the data. For example, data for February. The following example shows the output data for tank level in February for the Kimberley Pk Ground.  |
| Year | Returns the year of the data. For example, data for 2018. The following example shows the output data, which has remained at 2.83, for tank level in 2018 for the Kimberley Pk Ground.  |
For information on setting up custom equations and syntax, please refer to Analytical Functions.