Date Time

This generator creates date and time values.

How to use the “Date time” generator:

  • Random values
    • Randomly generate values in a range between minimum and maximum limits of time unit (second, minute, etc.)
    • Based on.
      • Now. Will use the current date time as a reference.
      • Actual field value. Will use the date time value from the field in the original message.
      • A specific date. You can specify a date and time to use as a reference.
    • Date format. Set the format of the new date-time. Note that you have a choice of formats. You can also enter your own format manually.
    • Include random blanks. Allowing random blanks will mean that you generate empty strings among the values for use in the field or data type.
  • Sequential list
    • Generate a sequence of date-time like: 2013-12-12, 2013-12-13, 2013-12-14, 2013-12-15, etc.
    • Based on.
      • Now. Will use the current date time as a reference.
      • Actual field value. Will use the date time value from the field in the original message.
      • A specific date. You can specify a date and time to use as a reference.
    • Date format. Set the format of the new date-time. Note that you have a choice of formats. You can also enter your own format manually.
    • Increment by. The step to use between each generation. You can use a negative value and set a time unit (second, minute, etc.)
    • Start new line. Always start with the minimum limit or the maximum limit if you’re using a negative increment.
    • Continue from previous list. If you run the De-Identication and it ends with 2013-12-13, next time, it will start with 2013-12-14.

 

Example #1:

  • Random values
  • In a range between: 10 and 1000 Day
  • Based on: A specific date (2012-01-01 00:00:00)
  • Date format: yyyyMMdd
  • Include random blanks: unchecked
Generated Value Description
20120318 Reference date + 77 days
20120614 Reference date + 165 days
20140102 Reference date + 732 days
20120212 Reference date + 42 days
20130508 Reference date + 493 days
Example #2:

  • Sequential list
  • In a range between: 0 and 1440 Minute
  • Based on: A specific date (2012-01-01 09:15:30)
  • Date format: yyyyMMddHHmmss
  • Increment by: 15 minutes
Generated Value Description
20120101091530 Reference date + 0 minutes
20120101093030 Reference date + 15 minutes
20120101094530 Reference date + 30 minutes
20120101100030 Reference date + 45 minutes
20120101101530 Reference date + 60 minutes
Example #3:

  • Sequential list
  • In a range between: 0 and 30 Minute
  • Based on: A specific date (2012-01-01 09:15:30)
  • Date format: yyyyMMddHHmmss
  • Increment by: 10 minutes
Generated Value Description
20120101091530 Reference date + 0 minutes
20120101092530 Reference date + 10 minutes
20120101093530 Reference date + 20 minutes
20120101094530 Reference date + 30 minutes
20120101091530 Reference date + 0 minutes

When the generator exceeds the maximum value (30), the sequence is reset starting at the minimum value (0).

 

Example #4: Manipulate date of birth

  • Random values
  • In a range between: -3650 and 3650 Day
  • Based on: Actual field value
  • Date format: yyyyMMdd
  • Include random blanks: unchecked
Original field Value Generated Value
19130113 19110213
19900909 20000812
19850909 19870514
19601020 19650218
19800317 19880617