# Date/Time

EasyCatalog also supports the re-formatting of date and time fields. By changing a field’s type to be `Date/Time`, EasyCatalog is able to sort data correctly in the panel. In some situations the output format should be the same as the input format: this is useful when the panel should be sorted by date or time.

Any date or time can be broken down into individual components called *specifiers*. Each specifier begins with a `%` symbol followed by a letter. For example, a four-digit year like 2025 is represented by `%Y`.

<figure><img src="https://1939597359-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FazTsFGbHKYYVlYs8LIQv%2Fuploads%2FSdaDC085veOXoXPD8CaY%2Fdate_time.png?alt=media&#x26;token=846897ae-a169-4944-98f1-9a69bf500eab" alt="Field Options panel > Format Pane > Date/Time"><figcaption><p>Field Options panel > Format Pane > Date/Time</p></figcaption></figure>

By combining multiple specifiers, you can define the format of any date or time. To do this effectively, you need to understand two key elements:

* **Input Format**: the structure of the original source data
* **Output Format:** the desired display format

Now, imagine your data source provides a date field with the following format: 12/24/2025 and you want to display it a more formal way, like Wednesday, the 24th of December, 2025. The value for import format should be `%m/%d/%Y`:

* `%m`: 12
* `%d`: 24
* `%Y`: 2025

And for the output format, you should type `%A, the %dth of %B, %Y`.

* `%A`: Wednesday
* `, the`: literal text
* `%d`: 24
* `th of`: literal text
* `%B`: December
* `%Y`: 2025

### List of specifiers

<table><thead><tr><th width="219.6484375">Specifier</th><th width="292.6796875">Description</th><th>Example</th></tr></thead><tbody><tr><td>%d-%m-%y %H:%M:%S</td><td>Year represented by 2 digits.<br>day-month-year hours:minutes:seconds</td><td><code>17-06-19 09:11:47</code></td></tr><tr><td>%Y-%m-%d %H:%M:%S</td><td>Year shown in full.<br>year-month-day hours:minutes:seconds</td><td><code>2019-06-17 09:11:47</code></td></tr><tr><td>%y-%m-%d %H:%M:%S</td><td>Year represented by 2 digits.<br>year-month-day hours:minutes:seconds</td><td><code>19-06-17 09:11:47</code></td></tr><tr><td>%d/%m/%Y</td><td>day/month/year</td><td><code>17/06/2019</code></td></tr><tr><td>%m/%d/%Y</td><td>month/day/year</td><td><code>06/17/2019</code></td></tr><tr><td>%d/%A/%Y</td><td>day/abbreviated weekday name/year</td><td><code>06/Mon/2019</code></td></tr><tr><td>%Ec</td><td>Current date&#x26;time on your computer</td><td><code>6/17/2019 9:11:47AM</code></td></tr><tr><td>%a</td><td>Abbreviated weekday name</td><td><code>Thu</code></td></tr><tr><td>%A</td><td>Full weekday name</td><td><code>Thursday</code></td></tr><tr><td>%b</td><td>Abbreviated month name</td><td><code>Aug</code></td></tr><tr><td>%B</td><td>Full month name</td><td><code>August</code></td></tr><tr><td>%c</td><td>Date and time representation</td><td><code>Thu Aug 23 14:55:02 2001</code></td></tr><tr><td>%C</td><td>Year divided by 100 and truncated to integer (00-99)</td><td><code>20</code></td></tr><tr><td>%d</td><td>Day of the month, zero-padded (01-31)</td><td><code>23</code></td></tr><tr><td>%D</td><td>Short MM/DD/YY date, equivalent to %m/%d/%y</td><td><code>08/23/01</code></td></tr><tr><td>%e</td><td>Day of the month, space-padded ( 1-31)</td><td><code>23</code></td></tr><tr><td>%F</td><td>Short YYYY-MM-DD date, equivalent to %Y-%m-%d</td><td><code>2001-08-23</code></td></tr><tr><td>%g</td><td>Week-based year, last two digits (00-99)</td><td><code>01</code></td></tr><tr><td>%G</td><td>Week-based year</td><td><code>2001</code></td></tr><tr><td>%h</td><td>Abbreviated month name (same as %b)</td><td><code>Aug</code></td></tr><tr><td>%H</td><td>Hour in 24h format (00-23)</td><td><code>14</code></td></tr><tr><td>%I</td><td>Hour in 12h format (01-12)</td><td><code>02</code></td></tr><tr><td>%j</td><td>Day of the year (001-366)</td><td><code>235</code></td></tr><tr><td>%m</td><td>Month as a decimal number (01-12)</td><td><code>08</code></td></tr><tr><td>%M</td><td>Minute (00-59)</td><td><code>55</code></td></tr><tr><td>%n</td><td>New-line character (‘\n’)</td><td></td></tr><tr><td>%p</td><td>AM or PM designation</td><td><code>PM</code></td></tr><tr><td>%r</td><td>12-hour clock time</td><td><code>02:55:02 pm</code></td></tr><tr><td>%R</td><td>24-hour HH:MM time, equivalent to %H:%M</td><td><code>14:55</code></td></tr><tr><td>%S</td><td>Second (00-61)</td><td><code>02</code></td></tr><tr><td>%t</td><td>Horizontal-tab character (‘\t’)</td><td></td></tr><tr><td>%T</td><td>ISO 8601 time format (HH:MM:SS), equivalent to %H:%M:%S</td><td><code>14:55:02</code></td></tr><tr><td>%u</td><td>ISO 8601 weekday as number with Monday as 1 (1-7)</td><td><code>4</code></td></tr><tr><td>%U</td><td>Week number with the first Sunday as the first day of week one (00-53)</td><td><code>33</code></td></tr><tr><td>%V</td><td>ISO 8601 week number (00-53)</td><td><code>34</code></td></tr><tr><td>%w</td><td>Weekday as a decimal number with Sunday as 0 (0-6)</td><td><code>4</code></td></tr><tr><td>%W</td><td>Week number with the first Monday as the first day of week one (00-53)</td><td><code>34</code></td></tr><tr><td>%x</td><td>Date representation</td><td><code>08/23/01</code></td></tr><tr><td>%X</td><td>Time representation</td><td><code>14:55:02</code></td></tr><tr><td>%y</td><td>Year, last two digits (00-99)</td><td><code>01</code></td></tr><tr><td>%Y</td><td>Year</td><td><code>2001</code></td></tr><tr><td>%z</td><td>ISO 8601 offset from UTC in timezone (1 minute=1, 1 hour=100)<br>If timezone cannot be determined, no characters</td><td><code>+100</code></td></tr><tr><td>%Z</td><td>Timezone name or abbreviation<br>If timezone cannot be determined, no characters</td><td><code>CDT</code></td></tr><tr><td>%%</td><td>A % sign</td><td><code>%</code></td></tr></tbody></table>

{% hint style="danger" %}
If the incorrect Input Format is specified, the field's content will be set to '???'
{% endhint %}

### Prefix for other languages

Dates can be prefixed to support other spoken languages.

Month and weekday names are automatically localized when formatting dates. By default, they follow the language set in your InDesign user interface. However, you can override this by prefixing the date format with the desired language. For example:

```
[es_ES]%d %B %Y
```

For the above setting, if your field content is `23/04/2025` and the input format is `%d/%m/%Y` the field content will be displayed with Spanish month names: `23 abril 2025`.