Add More Date Format Options

Hi everyone,

Like many of you in this community, I love Monday.com; however, not having more Date Format Options is a major pain point for my team and me. I imagine it’s also a pain point for many users that use Monday.com every day to schedule tasks and projects.

Some users might not even realize how much better it would be to have more date formats options. It’s just hard to think only in “name of month and day of the month” format (e.g. April 29) since most of us think of our weeks by the “day of the week” (e.g., Wednesday).

Also, not having a date format option with the “day of the week” in it (e.g., Wed Apr 29) for an app named Monday.com is sacrilegious :slightly_smiling_face: jk Love you Monday.com Team, but please add this feature.

My feature request is to Add More Date Format Options

I’m hoping the incredible Monday.com dev/product team can make this happen in short order :slightly_smiling_face:

For example:

Wed Apr 29
(Three-letter day of week abbreviation, three-letter day of month abbreviation and day of the month)

For previous years it would be:
Wed Apr 29, 2019
(Three-letter day of week abbreviation, three-letter day of month abbreviation, day of the month and year)

Another format:
2020-04-29
(ISO 8601 format YYYY-MM-DD)

There are many more date formats that users might want to use for their specific use case and context. Also, different countries use different date formats, so this would likely be helpful for users. Microsoft Excel has over 10 default date formats and you can create custom date formats as well.

Currently, there’s only one Date Format for the Date Column - for example:

Apr 29

You can add a time to the date - for example:

Apr 29, 09:00AM

For dates in previous years this changes to the following:

Apr 29, 2019
Apr 29, 2019, 09:00AM

There’s an option under Account > My Profile > Preferences > Date Format to modify the order - for example:

April 29, 2020 vs. 29 April 2020

(Although Monday.com shows the full spelling of the month here it uses the three-letter month appreciation in the app)

Background:

I run a mid-size construction company, specifically a roofing company. I have 15 internal employees and 50 sub-contractors. I have four project managers that work in the field and a project coordinator in the office. They use Monday.com to schedule and report on projects.

Use Case and Pain Point Overview:

Here’s a video that provides an overview of my use case and paint:
https://www.loom.com/share/b1754f28105244beb3dda78e26555821

Given that a key use case of Monday.com is scheduling and project management, not having more date format options is a major pain point. It’s also challenging for my team, in part, because the metal model people use for planning is days of the week.

What I mean by that is, most people can tell you what day of the week it is (e.g., Wednesday) if you ask them; however, many people would need to look at a calendar to know what the date is (e.g., April 29). Hopefully, everyone knows what month and year it is, but you never know :slight_smile:

In the iOS app, you can include the name of the day of the week, but then you also have to have the time with it and since you need to add it by the minute with the “date picker”, which IMO is a poor user interface:
https://developer.apple.com/design/human-interface-guidelines/ios/controls/pickers/

I do realize that I can use a Calendar View or Timeline View of a board, but for me, and I would imagine for many users, the Main/Table (Default) view is the primary view used. I also know that on the web, I can click the date and the calendar pops up, but that’s clunky and doesn’t let me see all the dates at a glance.

Finally, since my project managers are field workers, they only use the iOS app, and they can’t click the date and have the calendar pop up as that’s not how it works in iOS. As mentioned, the date picker comes up.

The only workaround I could imagine is to create a text column beside the date column and manually type in the day of the week. However, that would be a pain and time consuming, especially since dates more around quite a bit because of the schedules change in construction due to delays and weather. I used to work at IBM, and managed projects and dates often change in that context as well.

Absolutely! We need this as well!

In addition to having date formatting options available in relevant date columns in boards, this also needs to extend to how dates are selected within forms.

Ideally, I would think that the display of dates should be as selected in the user preferences, under My Profile.

Yes! Totally agree. More date formats in the boards and in forms would be amazing. Also more time, phone, and location formats! My use case would mostly be notifications. Using the Date ID Variable in the integration setup results in ‘YYYY-MM-DD’. Would love to at least see ‘MM-DD-YYYY’ and ‘Mon, Sept 7’, etc… Thanks for posting! @bd1234