Skip to content


Generate a random date in a specified interval.


Name Description Default Required Supported DB types
column Name of the column to be affected Yes date, timestamp, timestamptz
min The minimum threshold date for the random value. The format depends on the column type. Yes -
max The maximum threshold date for the random value. The format depends on the column type. Yes -
truncate Truncate the date to the specified part (nano, second, minute, hour, day, month, year). The truncate operation is not applied by default. No -
keep_null Indicates whether NULL values should be replaced with transformed values or not true No -


The RandomDate transformer generates a random date within the provided interval, starting from min to max. It can also perform date truncation up to the specified part of the date. The format of dates in the min and max parameters must adhere to PostgreSQL types, including DATE, TIMESTAMP WITHOUT TIMEZONE, or TIMESTAMP WITH TIMEZONE. The behaviour for NULL values can be configured using the keep_null parameter.

Example: Generate modifieddate

In the following example, a random timestamp without timezone is generated for the modifieddate column within the range from 2011-05-31 00:00:00 to 2013-05-31 00:00:00, and the part of the random value after day is truncated.

RandomDate transformer example
- schema: "sales"
  name: "salesorderdetail"
    - name: "RandomDate"
        column: "modifieddate"
        keep_null: false
        min: "2011-05-31 00:00:00"
        max: "2013-05-31 00:00:00"
        truncate: "day"
Expected result
| column name  | original value      | transformed         |
| modifieddate | 2007-06-23 00:00:00 | 2005-12-08 00:00:00 |