# 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)