Interval

returns an interval covering the period between the start date and time and the end date and time, inclusive syntax interval(startdatetime, enddatetime) enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd business object category yes/no business rules before save rules yes business rules calculation rules (after save, with or without also recalculate on load) yes business rules calculation rules (before save or always, without also recalculate on load) yes business rules calculation rules (before save or always, with recalculate on load) yes business rules editing rules yes business rules initialization rules yes business rules read only rules yes business rules required rules yes business rules validation rules yes client expressions yes object permissions yes services yes ldap yes mobile yes quick actions (except ui quick actions) yes ui quick actions yes reports yes search/dashboard without field references yes search/dashboard with field references yes parameter parameter description startdatetime the date and time of the beginning of the interval enddatetime the date and time of the end of the interval return value datetime interval in utc time example $(interval("1/31/2014 11 36 am", "2/2/2014 11 36 am")) returns the interval between the two dates although the values for the startdatetime and enddatetime parameters are in utc, as with all datetime literals in expressions, these are written in the locale and time zone of the current user $(mydate during interval("1/31/2014 11 36 am", "2/2/2014 11 36 am")) returns true if mydate is between the two datetime values, inclusive this function returns false otherwise $(mydate during interval(beginningofmonth( 3), endofmonth(0))) returns true if mydate is in the four month interval between the start of the month that was 3 months ago and the end of the current month