# CMS: Choosing a Format for Displaying Date and Time Collection Fields

Source: https://support.wix.com/en/article/cms-formatting-live-site-date-and-time-content-from-your-collection (updated 2026-11-09)
Related: Wix developer documentation, https://dev.wix.com/docs/llms.txt; Help Center index, https://support.wix.com/en/llms.txt

After connecting elements to 'Date', 'Date and Time', and 'Time' collection fields in the [CMS (Content Management System)](https://support.wix.com/en/article/cms-content-management-system-an-overview), you can control how the values are formatted on the live site. 

  
 For example, you could choose a **short date** format that renders a **Date** field as "10/31/26". Or you could choose a **full date time** format that renders a **Date and Time** field as "Thursday, October 31, 2026 at 12:12:12 PM PDT". 

  
 You can display these fields in text elements and in the text that appears in other elements such as buttons and galleries.

![Screenshot of most of the date and time formatting options.](https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/d6b40156-9694-4cfe-9209-54815ef9d6dc/2024/10/30/69365efe-8f06-4d0e-af8e-5f778a2d71a3/68ff0757-d9ee-40cf-9b87-391af250dff3.png)

### To choose a format for displaying date and time fields:

1. [Go to your editor](https://manage.wix.com/account/site-selector/?actionUrl=https%3A%2F%2Fwww.wix.com%2Feditor%2F%7BmetaSiteId%7D%3FeditorSessionId%3D%7Besi%7D%26).
2. Connect an element, such as text, to a [dataset](https://support.wix.com/en/article/cms-connecting-elements-to-a-collection-using-a-dataset) that connects to your collection.
3. Click the relevant field, for example **Text connects to**, in the dataset connections and select the **Date**, **Date and Time**, or **Time** field you want to display. If needed, you can select **+ Add** to create and connect a [new collection field](https://support.wix.com/en/article/cms-formerly-content-manager-adding-a-field-to-a-collection).

> **Note:** In the Wix Harmony Editor, you connect the element to your 'Date', 'Date and Time', or 'Time' field without a dataset. Then expand **Date format** (or **Time settings**) in the connection panel and choose a format from the **Show date as** (or **Time format**) dropdown.

![Screenshot of connecting text to a date and time field.](https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/d6b40156-9694-4cfe-9209-54815ef9d6dc/2024/10/30/b98338e7-f58e-4e66-80fd-fce342dcbe0d/a9199513-0ec4-4151-919c-43776b058dbb.png)

1. Click the **Choose a format** drop-down and select the format you want to display your dates or times in. View the format options in the table below:

| Format | Displayed as |
| --- | --- |
| Short date | 2/25/19 |
| Medium date | Feb 25, 2019 |
| Long date | February 25, 2019 |
| Full Date | Monday, February 25, 2019 |
| Short date time | 2/25/19, 8:45 PM |
| Long date time | February 25, 2019 at 8:45:00 PM |
| Full date time | Sunday, February 24, 2019 at 10:50:00 PM PST |
| Medium time (12h) | 8:45 PM |
| Medium time (24h) | 20:45 |
| Long time (12h) | 8:45:00 PM |
| Long time (24h) | 20:45:00 |
| Hour only | 8 PM |
| Minute only | 45 |
| Year only | 2019 |
| Month only | February |
| Short month only | Feb |
| Day only | Monday |

5\. Click **Publish** when you are ready to make the changes go live.

> **Notes:**
>
> * The date and times displayed on your live site adjust according to the visitor's local time zone.
> * Your site's [regional settings](https://support.wix.com/en/article/changing-your-sites-regional-settings) determine date and time language, time zones and other regional formatting options.
> * When you [export a collection to a CSV file](https://support.wix.com/en/article/cms-formerly-content-manager-exporting-content-from-your-collection), the time fields in the file are formatted as UTC+0\. They are not formatted to local time.
