# Date/Time format bug **URL:** \ **Category:** Account & Settings\ **Created:** [June 26, 2018, 7:04am UTC](https://community.hubspot.com/t/date-time-format-bug/9253 "2018-06-26T07:04:10Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![ld1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ld1/32/99949_2.png) [@ld1](https://community.hubspot.com/u/ld1)\ **Post date:** [June 26, 2018, 7:04am UTC](https://community.hubspot.com/t/date-time-format-bug/9253/1 "2018-06-26T07:04:10Z")
Hi team, I have the date and time format set to “Australian” in the account settings (example date shown in this area is correct, format is DD/MM/YYYY) ![Screen Shot 2018-06-26 at 17.01.57.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/8/88d6ae448ae116d2e3650d44df7f862d7112c6bf.png) When I create or modify tasks, the date is shown in the US format (MM/DD/YYYY). I’m not sure if this is elsewhere in the system as well, but I just noticed it as I was modifying a task a few minutes ago. ![Screen Shot 2018-06-26 at 17.02.51.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/9/49c6c22610482d6ac02b9adafbefdb3903d08e0e.png) ---
**Author:** ![SW1000](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sw1000/32/99782_2.png) [@SW1000](https://community.hubspot.com/u/SW1000)\ **Post date:** [July 18, 2018, 11:37am UTC](https://community.hubspot.com/t/date-time-format-bug/9253/2 "2018-07-18T11:37:03Z")
I have the same issue, despte changing the format in Account Defaults. I’ve tried changing this to US, and back to UK but no diffrence. All my Deal Close Dates, Tasks and everything else are in US format - confusing as \*\*bleep\*\* to look at a quick glance. 😞 ---
**Author:** ![Tanusha](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tanusha/32/21752_2.png) [@Tanusha](https://community.hubspot.com/u/Tanusha)\ **Post date:** [September 17, 2018, 7:16am UTC](https://community.hubspot.com/t/date-time-format-bug/9253/3 "2018-09-17T07:16:02Z")
Hi, we’re facing the same problem. We switched our timezone in Account Settings to GMT but all contacts, tasks and updates are happening in IST. Is there a solution to solve this? ---
**Author:** ![Jenny](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenny/32/24_2.png) [@Jenny](https://community.hubspot.com/u/Jenny)\ **Post date:** [September 21, 2018, 7:36pm UTC](https://community.hubspot.com/t/date-time-format-bug/9253/4 "2018-09-21T19:36:21Z")
Hi @Tanusha, Some information in your portal will be dependent upon your computer’s time zone settings. If you need to see elements in a different time zone, I would recommend changing your operating system’s time zone as well. Thanks, Jenny ---
**Author:** ![GailH](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gailh/32/74736_2.png) [@GailH](https://community.hubspot.com/u/GailH)\ **Post date:** [November 4, 2018, 12:05pm UTC](https://community.hubspot.com/t/date-time-format-bug/9253/5 "2018-11-04T12:05:43Z")
I’m a new HubSpot user based in UK and I’m also having the same problem with my date format showing in US mm/dd/yy when it should be dd/mm/yy. I’ve checked my operating system and the date format is showing correctly there. I’ve tried to import one contact as a test but it came up with errors on the fields with dates in. Any suggestions what I can do to solve the problem? ---
**Author:** ![SW1000](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sw1000/32/99782_2.png) [@SW1000](https://community.hubspot.com/u/SW1000)\ **Post date:** [November 5, 2018, 9:48am UTC](https://community.hubspot.com/t/date-time-format-bug/9253/6 "2018-11-05T09:48:02Z")
I actually found a fix for this about 2 months ago, but wanted to test it out for a while to be sure - all good so far! **You need to change this for every user that has an email address added to your Hubspot account**. Otherwise, you’ll change yours and it’ll be fine, but other users will still have the same issue as the system displays the data diffrently per user. And yes, this affects Sequences the same way etc… To Resolve: You need to click on your **user icon** in the **very top-right** of the Hubspot window (it either has your picture that you added, or a blank profile), and then click on **Profile and Preferences**. This opens you on the **Basic Info** page, where you can choose your **Country** (just below yoru Name and Lanugage). It automatically updates to the correct format now, but you use to be able to mix and match. **So now if you select United Kingdom it atomatically gives you the following Format:** _5 November 2018, 05/11/2018, and 1,234.56_ Great new little fix, but still odd how it works, thanks Hubspot 🙂 ---
**Author:** ![GailH](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gailh/32/74736_2.png) [@GailH](https://community.hubspot.com/u/GailH)\ **Post date:** [November 5, 2018, 3:11pm UTC](https://community.hubspot.com/t/date-time-format-bug/9253/7 "2018-11-05T15:11:01Z")
Your a life saver. It’s worked. Many thanks ---
**Author:** ![IanH](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ianh/32/93181_2.png) [@IanH](https://community.hubspot.com/u/IanH)\ **Post date:** [November 1, 2019, 3:39pm UTC](https://community.hubspot.com/t/date-time-format-bug/9253/8 "2019-11-01T15:39:46Z")
Brilliant job! ---
**Author:** ![Tanneke](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tanneke/32/75413_2.png) [@Tanneke](https://community.hubspot.com/u/Tanneke)\ **Post date:** [January 14, 2021, 6:32am UTC](https://community.hubspot.com/t/date-time-format-bug/9253/9 "2021-01-14T06:32:47Z")
Although I have set my own Profile to Australia, my Deal properties are STILL showing in US format. So yep, still hoping for an anwres Thanks ---
**Author:** ![MKaufmann](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mkaufmann/32/31639_2.png) [@MKaufmann](https://community.hubspot.com/u/MKaufmann)\ **Post date:** [September 14, 2021, 5:10am UTC](https://community.hubspot.com/t/date-time-format-bug/9253/10 "2021-09-14T05:10:29Z")
Hi all, Having the same problem here too - my Hub Id (20669128) Trying to figure out how to change date format from US to AUS. I have changed all suggested preferences and settings as per instructions (country, time zone, date format), I have checked date format of computer too, but dates from excel import still get changed from AUS to US date format. Any ideas what I could do? ![MKaufmann_0-1631596222856.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/5/50f53baad492c6eade4bc8bed432a7b700543979.png) ![MKaufmann_1-1631597032760.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/7/d77e30f84d3dd2e7b811e873b7c976f1d266160f.png) ---
**Author:** ![MKaufmann](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mkaufmann/32/31639_2.png) [@MKaufmann](https://community.hubspot.com/u/MKaufmann)\ **Post date:** [September 27, 2021, 3:13am UTC](https://community.hubspot.com/t/date-time-format-bug/9253/11 "2021-09-27T03:13:35Z")
Ok, I figured it out myself. It turns out that this issue only happens with uploads from xlsx files, but when I convert the xlsx to csv, the date format does not get changed by HubSpot when importing dates. ---
**Author:** ![JPrince](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@JPrince](https://community.hubspot.com/u/JPrince)\ **Post date:** [November 24, 2021, 1:46pm UTC](https://community.hubspot.com/t/date-time-format-bug/9253/12 "2021-11-24T13:46:53Z")
I have changed my user account settings - date & number format to UK. However the dates in my account fields are still showing as US format: mm/dd/yyyy Can someone help? Thanks!