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.

 Example

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".

 Example

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".

 Example

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".

 Example

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.

 Example

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.

 Example

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.