The Generate date in range masking activity allows you to generate a random date in the selected range.
|Table of contents|
To use the Generate date in range masking activity, it must be placed inside a table masking activity or a similar activity that iterates over data. Once placed, select the property you want to mask. Generating a date in a specific range requires two dates that define the range. Both the From date and To date dates can be manually entered, in which case they must be in a valid DateTime format or you can use the date selection dialog by clicking on the calendar button next to the input field
Figure 1: Date selection dialog
Additionally, you can set the DateOnly property to control whether only the date part of the base date should be changed, or if other properties (e.g. time values) should be changed as well.
In this example we want to generate dates for the expiration date column in the CreditCard table so that every generated value is in the year 2020. First we place the CreditCard masking activity into opened Package.xaml and put the Generate date in range masking activity within it. Once placed, we select the ExpirationDate property that we want to mask with generated dates. Here, we will select
1.1.2020. as the From date, and
31.12.2020. as the To date. This will ensure that every generated date will be in the year 2020. We leave other properties as they are.
Figure 2: Generating dates in range
|Property group||Property name||Description||Example|
|Input properties||DataItemProperty||The property to mask.||Write
|DateOnly||Whether the generator should produce only dates, without time.||
|FromDate||First part of date range used in data generation.||
|ToDate||Second part of date range used in data generation.||
|Input: Filter||Filter||Expression used for filtering records - only filtered items will be masked.||
|SkipDefaultValues||If true, default values will be omitted in masking (i.e. null values are not masked).||
|Input: Repeating||RepeaterId||The ID of the repeater that will be used to detect repeating and save results when masking item key repeats.||
|RepeatingKey||Key to use for repeating detection.||Write
|Misc||DisplayName||Display name of the activity in the workflow.||
|Result||Contains the masking definition object. It's a part of the masking infrastructure and should be ignored.||-|