DateTimeCalculator

Performs arithmetic on date, time, datetime, and interval values.

In Advanced Expression mode, composite expressions involving datetimes and intervals may be constructed.

See also: Date/Time Terminology, Date/Time Format, Date/Time Functions

The DateTimeCalculator performs arithmetic on five temporal types:

  1. Date
  2. Time
  3. Time with UTC offset
  4. Datetime
  5. Datetime with UTC offset

The input temporal strings must be in FME format or ISO 8601 format.

DateTimeCalculator also supports interval arithmetic, where the interval can be specified in one of two ways:

Invalid temporal and interval input will cause date time functions that consume them to return null, and cause the feature to be rejected.

Limitations:

Configuration

Input Ports

Output Ports

Note  Feature order may change in relation to other output ports. Feature order per port is maintained.

Parameters

Editing Transformer Parameters

Transformer parameters can be set by directly entering values, using expressions, or referencing other elements in the workspace such as attribute values or user parameters. Various editors and context menus are available to assist. To see what is available, click beside the applicable parameter.

For more information, see Transformer Parameter Menu Options.

Reference

Processing Behavior

Feature-Based

Feature Holding

No

Dependencies None
Aliases DateCalculator DateDifferenceCalculator
History  

FME Community

The FME Community has a wealth of FME knowledge with over 20,000 active members worldwide. Get help with FME, share knowledge, and connect with users globally.

Search for all results about the DateTimeCalculator on the FME Community.

 

Examples may contain information licensed under the Open Government Licence – Vancouver, Open Government Licence - British Columbia, and/or Open Government Licence – Canada.