Preface
RulePoint
RulePoint Concepts
- RulePoint Concepts Overview
- Understanding RulePoint Entities
Using RulePoint
RulePoint Objects
- RulePoint Objects Overview
- State of RulePoint Objects
Working with Topics
Working with Connections
Working with Sources
Working with Responders
Working with Responses
Working with Watchlists
Working with Analytics
- Analytics Overview
- Analytic Types
- Creating an Analytic
- Copying an Analytic
- Editing an Analytic
- Deleting an Analytic
- Viewing Related Objects
- Predefined Analytics
  - abs
  - average
  - ceil
  - charat
  - clean
  - compareto
  - concat
  - confidence
  - correlation
  - count
  - current
  - date
  - datedifference
  - endswith
  - even
  - floor
  - getcurrentdate
  - getdatefrommillis
  - getdateinmillis
  - geodistance
  - geoinbound
  - geoinsidearea
  - geointersect
  - geooutbound
  - geooutsidearea
  - geopassthru
  - indexof
  - integer
  - isblank
  - isholiday
  - isnum
  - istext
  - isweekday
  - isweekend
  - large
  - list2vars
  - lower
  - max
  - min
  - mod
  - mode
  - mround
  - odd
  - parse
  - past
  - percentile
  - power
  - proper
  - range
  - regex
  - replace
  - round
  - rounddown
  - roundup
  - sign
  - small
  - startswith
  - stdev
  - stringequals
  - stringindexof
  - stringlastindexof
  - stringlength
  - substring
  - sum
  - trim
  - truncate
  - upper
  - xpath
- Predefined Operators
  - contains
  - equalsSet
  - has
  - in
  - match
  - notMatch
  - search
  - unique
  - group by
  - distinct
  - unmatched
- Using the distinct, group by, and ummatched Filters
DRQL
Working with Rules
Working with Alerts
Setting Access Controls
Troubleshooting RulePoint Issues
Connecting to an Ultra Messaging Application
Creating an Ultra Messaging JMS Source

User Guide

6.2
- 6.1.2
- 6.1

Back Next

datedifference

The datedifference analytic returns the difference between two dates in terms of years, months, days, hours, minutes, seconds.

Syntax Option 1

datedifference(startdate,enddate,dateformat,units)

The following table describes the required and optional arguments:

Argument	Required Optional	Description
startdate	Required	The start date.
enddate	Required	The end date. The format of the start and end date must be same.
dateformat	Required	The date format followed for the start and end date.
units	Required	The difference unit. This can be years, months, days, hours, minutes, or seconds.

Example

when 1 yearsDiff  df with datedifference(df.startdate,df.enddate, df.dateformat,df.unit) as result = 1 then  response with body= “${result}”

The following table describes the result for the event property value that you pass:

Event Property Value	Description	Result
df.startdate= 2011/02/12 df.enddate= 2013/01/01 df.dateformat= yyyy/MM/dd df.unit=years	Returns the difference between two dates in terms of year.	1

Syntax Option 2

datedifference(starttime,endtime,timeformat,units)

The following table describes the required and optional arguments:

Argument	Required Optional	Description
starttime	Required	The start time.
endtime	Required	The end time. The format of the start and end time must be same.
timeformat	Required	The time format followed for the start and end date.
units	Required	The difference unit. This can be hours, minutes, or seconds.

Example

when 1 timeDiff df with datedifference(df.starttime,df.endtime, df.timeformat,df.unit) as result = 841 then  response with body= “${result}”

The following table describes the result for the event property value that you pass:

Event Property Value	Description	Result
df.starttime= 09:14:11 df.endtime= 23:15:35 df.dateformat= HH:mm:ss df.unit=minutes	Returns the difference between two times in terms of minutes.	841

Rename Saved Search

Table of Contents

User Guide

User Guide

datedifference

datedifference

Syntax Option 1

Syntax Option 2