Experience Builder (Excel Export Date Formatting Issue)

[JacobBlankenship1]

I am exporting a CSV from a table in Experience builder (through action widget) and the date format comes out as 3/22/2023 in the CSV. However the correct time format should be 3/22/2023, 5:37 PM. In Experience Builder it shows the correct information but gets truncated in the CSV export for some reason. 

Not sure if there is a setting I am missing or what.

I am using Enterprise Experience Builder Developer edition.

Thanks

[jcarlson]

Can you check the contents of the CSV in its raw text? Open it with Notepad or something similar, and verify how the date values are being saved. I've noticed that Excel applies default formatting to imported CSVs sometimes that I don't want.

[JacobBlankenship1]

@jcarlson Looked at it in notepad and it still came out in the same format of 3/23/2023

[JacobBlankenship1]

More information:

Experience builder Table View

When I export it as a JSON format the GPS time will be exported in Unix Epoch Time and than can be converted to a readable data format.

However, I need it to be in a csv format for the user to use.

[JacobBlankenship1]

@Jianxia Do you know of anyone that might be able to answer this question?

[Jianxia]

@JacobBlankenship1, it turns out a known issue. We will investigate it. Although the issue below is for the Query widget, it applies to any export to CSV actions.

BUG-000153124 In ArcGIS Experience Builder, the export as CSV option for the Query widget does not generate the full date and time

 

[SolanaFoo2]

Any updates on fixing this bug?  Thanks

[MarlboroughDistrict_Council]

I've just come across this as well. Clearly its not been fixed yet! Any update on a fix ESRI?