DateTime Transforms

Date Transform Functions Functions that operate on DateTime fields and that manipulate hours, minutes and seconds Purpose Use Date Transform functions to: Manipulate hours, minutes and seconds in a datetime field Calculate elapsed time...

Engineering Functions: [FLOORMIN(A,B)] Rounds a DateTime field down to a given interval, i.e., down to the nearest hour, 15 mins… FLOORMIN = Date &" " & Hour &":" & INT(Mins/Interval) * Interval &":00" Where  Date = ...

Engineering Functions: [HOD(A)] Returns the Hour portion from DateTime Field A. Purpose Use this function to: Group Data into hourly segments Determine hourly activity patterns across multiple days Extract hour of day data for use in other ca...

DateTime Transform: HOUR(A) Returns the Hour portion of DateTime A Purpose Use this function to: Extract the hour function of a TimeStamp Return the hour portion of a date time field Return Value Example Return Value: 0.....23 ...

DateTime Transform: HOURSBEFOREMAX(A) Returns the number of hours before the maximum value of DateTime A HOURSBEFOREMAX(A) =  HoursDiff(Max(A),A) where Max(A) = Maximum value in Field A A = Value of current record HoursDiff(...

DateTime Transform: HOURSDIFF(A,B) Returns difference in hours between DateTime A and DateTime B HOURSDIFF(A,B) - AbsoluteHours(B) - AbsoluteHours(A) Where AbsoluteHours(B) = number of hours from date reference to B AbsoluteHours(A) = n...

DateTime Transform: MINSDIFF(A,B) Returns difference in minutes between Time for DateTime A and Time for DateTime B MINSDIFF(A,B) = AbsoluteMinutes(B) - AbsoluteMinutes(A) Where AbsoluteMinutes(B) = number of minutes from date reference (whe...

DateTime Transform: MINUTE(A) Returns the minute portion of DateTime A Purpose Use this function to: Extract the minute section of the DateTime string Return Value Example Return Value: 0 to 59 Parameters JSON Sample ...

DateTime Transform: MOD(A) MINUTE OF DAY.  Return the number of minutes since the start of day for DateTime A Purpose Use this function to: Calculate the elapsed minutes since the start of the day Return Value Example Return...

DateTime Transform: SECOND(A) Returns the SECOND portion of DateTime A Purpose Use this function to: Extract the second section of a DateTime string Return Value Example Return Value: 0 to 59 Parameters JSON Sample U...

DateTime Transform: SECSDIFF(A,B) Returns difference in seconds between Time for DateTime A and Time for DateTime B SECSDIFF(A,B) = AbsoluteSeconds(B) - AbsoluteSeconds(A) Where AbsoluteSeconds(B) = number of seconds from date reference (wh...

DateTime Transform: SOD(A) Returns the number of seconds since the start of the day in DateTime A Purpose Use this function to: Calculate the number of elapsed seconds since the start of the day Return Value Example Return Value:...

DateTime Transform: TRUNKSEC(A) Truncates DateTime A to the nearest minute Purpose Use this function to: Group DateTime data into minute segments Return Value Example Return Value: [Date] HH:MM:00 Parameters JSON Sample ...

DateTime Transform: YMDH(A) Returns Year Month Day Hour of DateTime A in the format YYYYMMDDHH Purpose Use this function to: Create a discrete DataType from a continuous DateTime field ready for use in further engineering and analytical ope...