The Generate date masking activity allows you to generate a random date based on a base date with specific offset values.
|Table of contents|
To use the Generate date 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 requires a base date that will be used to generate new dates. Clicking on the ... opens the *DateTime Source Selector window.
Figure 1: DateTime Source Selector window
Here you can select the base date as the Property base value or an Absolute value that you set yourself. If you choose to you the absolute value, the format must be a valid DateTime format.
After you select the desired base date, you must enter the offset values. These dictate the range in which the random date will be chosen in regards with base date. These have to be TimeSpan instances. Note that you can use offset values to generate dates before the base date by providing the appropriate values.
Additionaly, 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 masking activity within it. Once placed, we select the ExpirationDate property that we want to mask with generated dates. Here, we will put
01/01/2020 as the base date. For the offsets, we put a new TimeSpan instance without any additional values as the minimal offset and an offset of 365 days in the maximum offset. This will ensure that every generated date will be in the year 2020. We leave other properties as they are.
Figure 2: Generating dates
|Property group||Property name||Description||Example|
|Input properties||AbsoluteBase||Absolute base date used for generation. Cannot be used with PropertyBase.||
|DataItemProperty||The property to mask.||Write
|DateOnly||Whether the generator should produce only dates, without time.||
|Max||Time difference maximum.||
|Min||Time difference minimum.||
|PropertyBase||Property base date used for generation. Cannot be used with AbsoluteBase.||
|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.||-|