Now

In CRM Analytics, create a column in a Data Prep recipe that displays the current date and time in a specified format.

User Permissions Needed
To create a recipe:	Edit CRM Analytics Dataflows OR Edit Dataset Recipes

This transformation works without interacting with any other columns.

In a Transform node of a Data Prep recipe, select the Formula button () in the Transform toolbar.
Select Now.
Select the date format.
Optionally, change the label of the column that stores the Now data in the Column Label field.
Click Apply to add the transformation to the Transform node.
The Preview tab shows the new Now column.
To view the Graph area, click the Collapse button ().
Save the recipe.

The Now option uses the date and time when the recipe last ran, based on UTC timezone.

Did this article solve your issue?

Let us know so we can improve!

Product Area