I think it would be very useful to be able to see and identify the timezone associated with time in a Date column. Currently, I am using a board of scheduling meetings with participants spread out over various timezones. I realize that the time is displayed in the local timezone of the user. However, that fact is not made clear when looking at dates/times in the future.
This functionally might be able to be paired with the World Clock column as a combo column.
Thanks and looking forward to hearing feedback or plans for this type of roll-out.
Monday.com needs to adjust in every function to the regional time/date of our countries.
Example we are from Argentina, and im not allowed to change to our date format.
This needs to be fixed too in exporting functions, example excel.
If you enter time and date as text, you can then use formula columns to convert the time and date to any timezone manually using +/- how many hours from the original.
It’s definitely clunky and a timezone converter would a great feature if @monday.com could implement natively!
{Date/Time (EST)} = original time/date text column name
900 = minutes difference (would need to work this out based on UTC +/- difference)
“MMM DD, HH:mm” = format of how I want the time/date displayed
Same. And then I keep on travelling so when I created it I started with the Eastern timezone and then flew in the Prairies and now it is showing Mountain time and have to move the conversion again. I wish* there is a functionality where there is a world clock for the time zone
Hi Marcus, I’ve been trying to use your provided formula and adapt it to my use case. I Cannot seem to get it to work. Hoping you might be able to help.
I have due date column with date and time. I am in CST and need to create another column that automatically take the Due Date input and converts to PKT (pakistan time). Here is what I was trying: FORMAT_DATE(ADD_HOURS({Due date},10), “MMM DD, HH:mm”)