how do I get Monday.com to display dates in the correct international format that every country other than the USA uses i.e. DD/MM/YYYY or 19th Feb 2025 ?
Its ONLY the USA that uses MM/DD/YYYY or MM ddd
how do I get Monday.com to display dates in the correct international format that every country other than the USA uses i.e. DD/MM/YYYY or 19th Feb 2025 ?
Its ONLY the USA that uses MM/DD/YYYY or MM ddd
It’s not a perfect solution. But it might work for your use case…
You can use a formula like this in a formula column to return the desired format:
FORMAT_DATE({Date}, "DD/MM/YYYY")
OR
FORMAT_DATE({Date}, "Do MMM YYYY")
You can see more details and formatting codes here: The monday Hidden Functions
Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
This! So frustrating
Thanks Monday Man !. I did eventually find this profile setting for monday.com… but obvious question is ‘Why aren’t they detecting and using the user’s browser language and date format’ but rather FORCING all users to default to the AMERICAN format !
We know that you wanted the ability to control your date and time preferences so we have added these settings to your profile page under the “Language and region” tab.
You can adjust your Date Column time format between 12hr or 24hr and your Date format between MM/DD/YY or DD/MM/YY:
Additionally, for further date customization options, check out the options found in the column settings! Simply hover over “Cell display” and then choose the desired format for your date display within your column cells.
How is this helpful ? How is this adding any ADDITIONAL information to what I clearly already know / stated in the original issue ?