---
title: "Format dates"
slug: "change-date-format"
description: "Specify that displayed dates rely on your Salesforce locale settings."
updated: 2022-11-02T15:23:46Z
published: 2022-11-02T15:23:46Z
canonical: "docs.zilliant.com/change-date-format"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Format dates

You can specify that displayed dates rely on your Salesforce locale settings. Doing this allows you to see and work with dates in a format that matches the customary format for your locale.

If you use locale settings to determine date display format, it affects all users. The date format will appear according to each user's locale setting.

You must specify your preferred date display option in each worksheet.

          Note

          

Follow the steps in [Change number format](/v1/docs/change-number-format) to change your locale settings.

1. In a worksheet, select **Column Settings**.
2. Select a date field.
3. On the **Column Settings** dialog, select **Locale** from the **Display Format** list.
4. Select **Save**.

The format of the updated date field matches the format associated with your locale.

For example, if your locale setting is **English (United States)**, the date appears in MM/DD/YYYY format. If your locale setting is **French**, then the date appears in DD/MM/YYYY format.

#### Limitations

When performing formulaic bulk updates, defining calculated columns, or defining KPI cards, you must manually enter dates (incuding the single quote marks) in one of the following formats:

- 'yyyy-mm-dd'
- 'mm-dd-yyyy'

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/table_60(2).png?sv=2026-02-06&spr=https&st=2026-11-07T16%3A18%3A25Z&se=2026-11-07T17%3A18%3A25Z&sr=c&sp=r&sig=JW71kiCltDX3fnV7c4%2F6y5a2S7EcwJbX25gmVZnxm5Q%3D)

Column Settings