Format date & time

Operating in different countries and languages? Display your time and date columns in a format that suits you best!

You're in the Helpcenter for Version 1 of our app! Version 2 is now available with enhanced features and a new user interface. 🎉

Need info on Version 2? Access the Help Center for Version 2

Want to upgrade or find out which version you have? Here´s how!

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

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)

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

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 Microsoft documentation - custom date and time formats