---
schema_version: "1"
id: b29da0e82c288ec49af48efa91469de027d48fcabf37263a6d8cc53bc441a651
title: Now
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_now.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_now.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bd1e3e4619690b5120753eb3c53954dd7f942ad5a7c9ceb1aa5a9d2c797bfc49
description: In CRM Analytics, create a column in a Data Prep recipe that displays the current date and time in a specified format.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Now

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

### Required Editions

## Now

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d17444e39">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d17444e39 ">To create a recipe:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d17444e39 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>

          </tr>
        </tbody>
      </table>

This transformation works without interacting with any other columns.

1. In a Transform node of a Data Prep recipe, select the Formula button (![Formula button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_transformation_formula.png)) in the Transform toolbar.
2. Select **Now**.
3. Select the date format.![The Now menu appears when you select Now.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_now.png)
4. Optionally, change the label of the column that stores the Now data in the Column Label field.
5. Click **Apply** to add the transformation to the Transform node.
    
    The Preview tab shows the new Now column.
    
    ![Preview shows the new Now column.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_now_column.png)
6. To view the Graph area, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_collapse.png)).
7. Save the recipe.

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