Date Only in Tables

[SavannahThomson1]

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.  

[SavannahThomson1]

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)

[EmilyGeo]

Hi @SavannahThomson1, 

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

[SavannahThomson1]

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.   

 

 

 

[EmilyGeo]

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

[SavannahThomson1]

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