topic Re: Change date in list widget to MM/DD/YYYY in ArcGIS Experience Builder Questions

Change date in list widget to MM/DD/YYYY

elpinguino — Mon, 13 Dec 2021 09:39:32 GMT

I have a list widget of comms records.

I populate each of the cards in the lists dynamically.

The date is set up in US format. How do I change it to MM/DD/YYYY. I'm pretty sure this can be done in arcade.

Re: Change date in list widget to MM/DD/YYYY

jcarlson — Tue, 21 Dec 2021 18:04:28 GMT

Experience Builder doesn't give you the same access to Arcade that you have in other apps. It will honor Arcade expressions in a Details widget, but not when piping attributes into a Text widget. Even looking at the config JSON of something like that, it's not clear how it's deciding the date format. Doesn't seem to be an exposed user setting, but it would be great if it were! You should suggest it as an idea.

Re: Change date in list widget to MM/DD/YYYY

elpinguino — Thu, 18 Aug 2022 00:52:17 GMT

Hi @ShengdiZhang , Just wanted to check in on this and see if this is being looked into in a future upgrade or if it has already, and I've missed it.

Re: Change date in list widget to MM/DD/YYYY

ShengdiZhang — Mon, 29 Aug 2022 05:47:10 GMT

Hi, there are no plans for when this feature will be implemented. However, if you want to use a different date format, you can update the format in the Map Viewer, and the Experience Builder will inherit this format.

Re: Change date in list widget to MM/DD/YYYY

PeterKT — Wed, 31 Aug 2022 22:29:39 GMT

Does this work when you use map viewer classic?

I tried with our 10.8.1 portal and I am using EXB dev 1.9 and it didn't make a difference.

Re: Change date in list widget to MM/DD/YYYY

ShengdiZhang — Wed, 07 Sep 2022 06:35:19 GMT

Hi, I tried changing the date format in Map viewer classic - configure popup - configure attributes, and the date format in the ExB map and text widgets change as well.

Are you using a table widget to display the data, it is a known bug that the table widget doesn't honor the date format configured in the map viewer.

Shengdi

Re: Change date in list widget to MM/DD/YYYY

MarcoPoetsch — Thu, 20 Oct 2022 00:44:26 GMT

Hi @ShengdiZhang ,

do you have any updates of when this bug will be addressed?
I'm currenlty using Dev Edition 1.9, and the bug is still present.

Thanks,
Marco

Re: Change date in list widget to MM/DD/YYYY

TonghuiMing — Mon, 24 Oct 2022 03:00:59 GMT

Hi @MarcoPoetsch - if you were talking about the table bug, it is under investigation by our colleague teams and will probably be fixed by them. I cannot get a clear milestone yet, but you can track a similar support issue if needed - BUG-000150108.

Re: Change date in list widget to MM/DD/YYYY

TonghuiMing — Mon, 24 Oct 2022 03:05:38 GMT

FYI - In Map Viewer Classic, most of the date formats (long, short, etc.) will be honored, except for one - DD/MM/YYYY - it contradicts the locale practice if in the US. Either one of MM/DD/YYYY and DD/MM/YYYY will be available depending on the user locale.

Re: Change date in list widget to MM/DD/YYYY

MarcoPoetsch — Tue, 25 Oct 2022 22:22:14 GMT

thanks Tonghui, I hope this will get fixed soon

Re: Change date in list widget to MM/DD/YYYY

PeterKT — Thu, 01 Dec 2022 04:21:47 GMT

I can also confirm in MapViewer Classic 10.8.1 my attribute has DD/MM/YYYY.

My PC's region was Australia English.

Chrome was Australian English

Edge was US English.

And Chrome got it right and Edge didn't.

It appears to be the language settings in the Browser, not your PC.

(Can't wait to upgrade to 10.9.1+ and leaving the Map Viewer Classic behind)

Re: Change date in list widget to MM/DD/YYYY

elpinguino — Thu, 23 Feb 2023 00:39:25 GMT

I was able to get around this by fixing it outside of Experience Builder in my ArcGIS Online settings for our organisation as an administrator. This worked for New Zealand English. https://doc.arcgis.com/en/arcgis-online/administer/configure-general.htm#ORG_NUMBER_DATE