Date solution

Several date variables require calculation and comparison when used by Pentaho Spoon. Date solution provides these calculations and comparisons.

There are three instances when date solution is required:
  1. Compare two dates. This comparison is used to determine whether a project is on time.
  2. Calculate duration between two dates in days. In some cases, this calculation is used to calculate the duration in hours.
  3. Compare a date, such as modified date or processed date, to a range of dates, such as first day of month and last day of month.

The first and second instances are solved by using JavaScript scripting steps.

The third instance is solved by using a date range in the table input.

There are two types of dates. Dates that are stored as a Date in the database and dates that are stored as a Number in the database.

Tip: All TRIRIGA® objects store Date and Date and Time fields as numbers in the database. Select a field as a number to interact with business object tables. Select a field as a date to interact with system platform table fields defined as date.