topic Re: Date Only in Tables in ArcGIS Experience Builder Questions

Date Only in Tables

SavannahThomson1 — Wed, 13 Aug 2025 16:42:15 GMT

When will date only fields be added to tables in experience builder and dashboards? Asking because trying to write an arcade script to replace that functionality is not working for me.

Re: Date Only in Tables

SavannahThomson1 — Wed, 13 Aug 2025 18:00:17 GMT

I finally got a workflow/arcade script that works for me!

if anyone needs to convert a text field that is formatted like mm/dd/yyyy to a date field, you can use this script:

function textToDate(textDate) {
if (IsEmpty(textDate) || textDate == null) {
return null
}
var parts = Split(textDate, "/")
return Date(
Number(parts[2]), // year
Number(parts[0]) - 1, // month (0-based)
Number(parts[1]) // day
)
}

var recordedDate = textToDate($feature.recorded_date)
var mappedDate = textToDate($feature.mapped_date)

Re: Date Only in Tables

EmilyGeo — Thu, 14 Aug 2025 15:30:16 GMT

Hi @SavannahThomson1,

Date only fields are currently displayed in the tables for both apps.

Re: Date Only in Tables

SavannahThomson1 — Wed, 13 Aug 2025 18:52:03 GMT

Hi Emily,

Date Only fields do not show up in tables added to experience builder or dashboards. You can see the first screen shot is from the data tab on the item description and the second screen shot is the table added to experience builder with the date field missing. My workaround was converting those fields to text in excel before publishing so they'll appear in my apps.

Re: Date Only in Tables

EmilyGeo — Thu, 14 Aug 2025 00:04:40 GMT

Are you using ArcGIS Online? Experience builder recently added support for the new field types with the June 2025 update. See the What's new blog article here https://doc.arcgis.com/en/experience-builder/latest/get-started/whats-new.htm

Re: Date Only in Tables

SavannahThomson1 — Thu, 14 Aug 2025 13:02:10 GMT

This is in Portal but that is exciting to see it has been added!