Skip to content

Date Functions

Date functions extract and format date/time values.

Goal

Display a formatted date or derive a date part for calculations.

Steps

  1. Open the Expression Builder.
  2. Choose the Date category.
  3. Insert the needed function and pass a date field or parameter.
  4. Apply and Preview.

[ Screenshot: Date functions in Expression Builder ]

Tips

Tip

Prefer Date / Date & Time parameters for user-entered ranges, then reference them with $P{} in queries and expressions.

See Also