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. |
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". |
Hour | Returns the hour of the day in military time. For example, 8:45 am outputs "8", while 8:45 pm outputs "20". |
Minute | Returns the minute of the hour. For example, 8:45 am outputs "45". |
Month | Returns the month of the data. For example, data for February. |
Year | Returns the year of the data. For example, data for 2018. |
For information on setting up custom equations and syntax, please refer to Analytical Functions.