Introduction

The format transform function is used to change a date value to a different format. For example:

"created_at":"2023-10-26T07:51:07-04:00"

...might be changed to:

1698321067

A range of predefined date formats is available for selection, or you can set your own custom format.

Adding a format date 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 format from the date category:

Step 5 Click in the format field to select a predefined date format that incoming dates should be converted to:

Step 6 Click the add field button:

Step 7 Click in source fields and select the source field to be used for this transform:

Step 8 Accept your changes (twice).

Step 9 Save the transform. You'll notice that the transform icon is updated to indicate that a transform function is present for the mapping row - for example:

Common format specifiers for custom dates

Internally, the format transform function uses Laravel's date format methods, which in turn call PHP date format methods. Commonly used format specifiers are listed below - full details are available in this Laravel guide.

Day-related

The following characters are commonly used to specify days in custom format dates.

Month-related

The following characters are commonly used to specify months in custom format dates.

Year-related

The following characters are commonly used to specify years in custom format dates.

Time-related

The following characters are commonly used to specify times in custom format dates.

Usage notes

Unix Epoch format

Unix Epoch dates must be received as a number, not a string - i.e.:

1701734400 rather than "1701734400"

If your Unix dates are provided as strings, you should convert these to numbers. To achieve this, add a cast to number transform for the date field BEFORE the date format transform function.

Transforms in this section

• Custom dynamic date

• Custom static date

• Format date

• Round date

Introduction

The round date transform function is used to round source dates to either the start or end of the day, where:

• start of day changes the time to 00:00 for the received date

• end of day changes the time to 23:59 for the received date

So, you can round a given source date before sending the rounded value into a given target field.

Adding a round date 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 round date:

Step 5 Choose your required rounding:

Step 6 Accept your changes and save the transformation - at this point your mapping row is displayed without a target. From here, you can go ahead and add a target field:

Introduction

The custom static date transform function is used to set a target field to a given date and time.

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 static date:

Step 5 Click anywhere in the date field, or click the calendar icon, to open a date picker:

Step 6 Set the required date and time.

Step 7 Accept your changes:

...then save the transformation:

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

...then:

...then:

Step 9 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 static date will be mapped to the given target field.

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:

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.