---
schema_version: "1"
id: 92222086cba9090cb8a656efdf891dc95a4dfc53ed01f4fbf40ffbca52f62b4c
title: Reserved Keywords in Formulas
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_string_keywords.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_string_keywords.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2784ebfae685f5d485cfb0d700c1d2d3c0ceeb790b7587521b738365e1a1ecf0
description: Batch data transforms have reserved keywords that need special handling when manually writing formulas. Use double quotes “ when referencing fields that share a name with reserved keywords. To avoid cross-referencing your field names with this list, the best practice is to use double quotes around all field names.
products:
  - Data 360
release: "264"
---
# Reserved Keywords in Formulas

Batch data transforms have reserved keywords that need special handling when manually writing formulas. Use double quotes “ when referencing fields that share a name with reserved keywords. To avoid cross-referencing your field names with this list, the best practice is to use double quotes around all field names.

Enclose fields that share a name with a reserved keyword in double quotes. For example, if your data has a field named **Month**, you can enter this expression:

```
case when "Month" = ‘New’ then ‘High’ else ‘Low’
```

## Reserved Keywords

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
        </colgroup>
        <tbody>
          <tr class="">
            <td class="slds-cell-wrap" style="vertical-align:top;">
              <ul class="simple">
                <li>
                  <code>ABS</code>
                </li>

                <li>
                  <code>ADD_MONTHS</code>
                </li>

                <li>
                  <code>AND</code>
                </li>

                <li>
                  <code>ARRAY</code>
                </li>

                <li>
                  <code>ARRAY_JOIN</code>
                </li>

                <li>
                  <code>ARRAY_CONTAINS</code>
                </li>

                <li>
                  <code>BETWEEN</code>
                </li>

                <li>
                  <code>CASE</code>
                </li>

                <li>
                  <code>CEIL</code>
                </li>

                <li>
                  <code>CHAR_LENGTH</code>
                </li>

                <li>
                  <code>COALESCE</code>
                </li>

                <li>
                  <code>CONCAT</code>
                </li>

                <li>
                  <code>CONTAINS</code>
                </li>

                <li>
                  <code>CURRENT_DATE</code>
                </li>

                <li>
                  <code>CURRENT_TIMESTAMP</code>
                </li>

                <li>
                  <code>DATE_ADD</code>
                </li>

                <li>
                  <code>DATEDIFF</code>
                </li>

                <li>
                  <code>DATE_FORMAT</code>
                </li>

                <li>
                  <code>DATE_SUB</code>
                </li>

                <li>
                  <code>DATE_TRUNC</code>
                </li>

                <li>
                  <code>DAY</code>
                </li>

                <li>
                  <code>DAYOFMONTH</code>
                </li>

                <li>
                  <code>DAYOFWEEK</code>
                </li>

                <li>
                  <code>DAYOFYEAR</code>
                </li>

                <li>
                  <code>DISTINCT</code>
                </li>

                <li>
                  <code>ELSE</code>
                </li>

                <li>
                  <code>END</code>
                </li>

              </ul>
            </td>

            <td class="slds-cell-wrap" style="vertical-align:top;">
              <ul class="simple">
                <li>
                  <code>ENDSWITH</code>
                </li>

                <li>
                  <code>EXP</code>
                </li>

                <li>
                  <code>FALSE</code>
                </li>

                <li>
                  <code>FROM</code>
                </li>

                <li>
                  <code>FLOOR</code>
                </li>

                <li>
                  <code>FORMAT_NUMBER</code>
                </li>

                <li>
                  <code>FROM_UNIXTIME</code>
                </li>

                <li>
                  <code>HOUR</code>
                </li>

                <li>
                  <code>IN</code>
                </li>

                <li>
                  <code>INTERVAL</code>
                </li>

                <li>
                  <code>IS</code>
                </li>

                <li>
                  <code>ISNTR</code>
                </li>

                <li>
                  <code>LAST_DAY</code>
                </li>

                <li>
                  <code>LIKE</code>
                </li>

                <li>
                  <code>LOG</code>
                </li>

                <li>
                  <code>LOWER</code>
                </li>

                <li>
                  <code>LTRIM</code>
                </li>

                <li>
                  <code>MINUTE</code>
                </li>

                <li>
                  <code>MONTH</code>
                </li>

                <li>
                  <code>MONTHS_BETWEEN</code>
                </li>

                <li>
                  <code>NEXT_DAY</code>
                </li>

                <li>
                  <code>NOW</code>
                </li>

                <li>
                  <code>NOT</code>
                </li>

                <li>
                  <code>NULL</code>
                </li>

                <li>
                  <code>NULLIF</code>
                </li>

                <li>
                  <code>OR</code>
                </li>

                <li>
                  <code>POWER</code>
                </li>

              </ul>
            </td>

            <td class="slds-cell-wrap" style="vertical-align:top;">
              <ul class="simple">
                <li>
                  <code>QUARTER</code>
                </li>

                <li>
                  <code>REPLACE</code>
                </li>

                <li>
                  <code>ROUND</code>
                </li>

                <li>
                  <code>RTRIM</code>
                </li>

                <li>
                  <code>SECOND</code>
                </li>

                <li>
                  <code>SIZE</code>
                </li>

                <li>
                  <code>SPLIT</code>
                </li>

                <li>
                  <code>SQRT</code>
                </li>

                <li>
                  <code>STRING</code>
                </li>

                <li>
                  <code>SUBSTR</code>
                </li>

                <li>
                  <code>SUBSTRING</code>
                </li>

                <li>
                  <code>STARTSWITH</code>
                </li>

                <li>
                  <code>THEN</code>
                </li>

                <li>
                  <code>TITLE</code>
                </li>

                <li>
                  <code>TO</code>
                </li>

                <li>
                  <code>TO_DATE</code>
                </li>

                <li>
                  <code>TO_TIMESTAMP</code>
                </li>

                <li>
                  <code>TO_UNIX_TIMESTAMP</code>
                </li>

                <li>
                  <code>TRIM</code>
                </li>

                <li>
                  <code>TRUE</code>
                </li>

                <li>
                  <code>TRUNC</code>
                </li>

                <li>
                  <code>TRUNCNUMBER</code>
                </li>

                <li>
                  <code>UPPER</code>
                </li>

                <li>
                  <code>WHEN</code>
                </li>

                <li>
                  <code>WEEK</code>
                </li>

                <li>
                  <code>WEEKOFYEAR</code>
                </li>

                <li>
                  <code>YEAR</code>
                </li>

              </ul>
            </td>

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

## Additional Keywords for Multiple Row Formulas

These keywords are reserved in formulas with the **Multiple row formula** turned on. Use double quotes `"` when referencing fields that have any of these names.

- `CURRENT`
- `DENSE_RANK`
- `FIRST_VALUE`
- `LAG`
- `LAST_VALUE`
- `LEAD`
- `RANK`
- `ROW_NUMBER`
- `SUM`