# Format date & time

## Format date and time columns

By default, the format of the date depends on the language/ country setting in your monday.com account.

But Microsoft Word offers a lot of additional options to format dates and times. To change the default output of your date or time, you can use these Microsoft Word formatting options in your DOCX template. 

This way you can format any date/hour/time column and also [number column](https://help.docexport.com/template/customization/format-numbers) from your own monday.com board.

### **Date Column Format** 

To format your placeholder, add a straight line (pipe symbol) after the name of your placeholder and then add the format string you want to use.

e.g. **`{{Item.Date | D}}`** for: **Tuesday, December 24, 2024**

Find all standard date and time format strings here:\
[Microsoft documentation - standard date and time formats](https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings)

or **`{{Item.Date | yyyy-MM-dd}}`** for: **2025-12-24**

or **`{{Item.Date | dd.MM.yyyy}}`** for: **24.12.2025**

or **`{{Item.Date | dd/MM/yyyy}}`** for: **24/12/2025**

or **`{{Item.Date | MM-dd-yyyy}}`** for: **12-24-2025** (US date format)

or **`{{Item.Date | ddd, dd MMM}}`** for: **Wed, 24 Dec**

Note: 'Date' is the title of your column:

**`{{Item.ColumnTitle | dd.MM.yyyy}}`**

If your column title is 'Task Due', the placeholder would be:

**`{{Item.Task Due | dd.MM.yyyy}}`**

Find all custom date and time format strings here:\
[Microsoft documentation - custom date and time formats](https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings)

### **Today's date**

To insert today's date in your documents, you can simply use the term "Today" instead of referring to a column title.

e.g. **`{{Today | D}}`** for: **Wednesday, January 01, 2025**

or **`{{Today | yyyy-MM-dd}}`** for: **2025-01-01**

or **`{{Today | dd.MM.yyyy}}`** for: **01.01.2025**

or **`{{Today | dd/MM/yyyy}}`** for: **01/01/2025**

or **`{{Today | MM-dd-yyyy}}`** for: **12-24-2025** (US date format)

### **Time of document created**

To insert the time that the document was created, us the placeholder {{Now}}

e.g. **`{{Now}}`** for: **22:30**

e.g. **`{{Now | hh:mm tt}}`** for: **10:30 pm**

### **Date and Time of document created**

To insert the date and time, simply combine both placeholders:

e.g. **`{{Today}} at {{Now}}`** for: **24/12/2025 at 22:30**

e.g. **`{{Today}} {{Now | hh:mm tt}}`** for: **24/12/2025 10:30 pm**

### **Hour Column Format**

You can also format your hour columns in the same way. 

e.g. **`{{Hour Column Name | en-US}}`** for: **1:30:00 PM**

You can find all custom and standard time format strings here: \
[Microsoft documentation - standard date and time formats](https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings)\
[Microsoft documentation - custom date and time formats](https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.docexport.com/template/customization/format-date-and-time.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.