Custom dynamic date transform function

Introduction

The custom dynamic date transform function is used to set a target field to the current date and time, based on the date and time that the process flow runs. You can also define rounding and adjustments.

Adding a custom string transform

Step 1 In your process flow, access settings for your map shape:

Step 2 Select the add transform button for the required mapping rule - for example:

Step 3 Click the add transform button:

Step 4 Click in the name field to access a list of all available transform functions, then select custom dynamic date:

Step 5 Optionally, you can add adjustment settings - for example:

These options are summarised below:

FieldSummaryExample

Round

  • Select start of day to change the time to 00:00:00 for the date the process flow is run.

  • Select end of day to change the time to 23:59:59 for the date the process flow is run .

Suppose that the process flow runs at the following date/time: 2023-08-10 10:30:0 If set to start of day, the transformed value would be 2023-08-10 00:00:00. If set to end of day, the transformed value would be 2023-08-10 23:59:59.

Units

If you want to adjust the date/time, select the required unit - choose from second, minute, hour, day, week, month or year.

Suppose that the process flow runs at the following date/time: 2023-08-10 10:30:0 and you want to adjust it by 1 day. In this case, you would select day as the unit and specify 1 as the adjustment value. However, if you wanted to adjust by 1.5 days, you would set the unit to hour and specify 36 as the adjustment value.

Adjustment

Having selected an adjustment unit, enter the required number of that unit here.

See units examples above.

Step 6 Accept your changes:

...then save the transformation:

Step 7 Now you can select a target field in the usual way - for example:

...then:

...then:

Step 8 Once your mapping is complete, the row should be displayed without a source field - for example:

From here you can save changes or add more mapping rules as needed. Next time the process flow runs, the custom dynamic date will be mapped to the given target field.

Last updated