topic Re: Formating date fields in ArcGIS Pro Report in ArcGIS Pro Questions

Formating date fields in ArcGIS Pro Report

DSIProvince_Nord — Wed, 26 Feb 2020 02:57:40 GMT

Hi,

I am trying to figure out how to properly set date fields in a report :

Report is based on a hosted feature layer (Portal), open in AGPro and most of the report is working well but in the Details section, I try to add a field element from my feature service, which is a date field, and I am facing several issues 1- Field is from the FS and not from the current date or MapFrame date, so type="date" and type="time" does not work. And formatting the dynamic text (<dyn type="report" property="field-value" field="fin" format="dd/MM/yyyy"/>) doesn't work either. It is like the date field is considered a string-field

Alternatively I could set up an Arcade field returning a string value with date and/or time, but Arcade field seems not supported in Reports. Manually setting expression/expr0 in the dynamic field doesn't print the Arcade value but only the string "expression/expr0".

2- I have a time zone issue : Living in New Caledonia, the time zone is GMT+11. In my feature service, WebMap, web app etc... the time zone is correct, but in the report, it is not supported and every time before 11AM appears as the day before... I noticed in my feature service : Date fields Time Zone: UTC(Daylight Savings Time not supported), it may be related but I don't really know.

3- not related to the date field issue, I set an integer field with prestring, poststring and emptystring parameters (<dyn type="report" property="field-value" field="pr_m" preStr="+ " postStr=" m" emptyStr="..."/>) preStr and postStr work, but emptyStr doesn't work, maybe it works only with string field ?

Any help would be appreciated

Thanks

Re: Formating date fields in ArcGIS Pro Report

TanuHoque — Thu, 28 Jan 2021 23:48:19 GMT

Hi @DSIProvince_Nord,

Could you pls share some screenshots to describe your problems? If you happen to have your web app/map public, that'd be great too.

thanks

Tanu

Re: Formating date fields in ArcGIS Pro Report

TanyaBagley-Online — Mon, 20 Sep 2021 14:24:11 GMT

Was this issue ever resolved? If so could you share the resolution? I am having the same issue with my date fields getting messed up from a hosted feature service. It works for a long time and then randomly stops working and it won't export the date properly and shows it as a string field.

Re: Formating date fields in ArcGIS Pro Report

TanuHoque — Mon, 20 Sep 2021 16:02:56 GMT

@TanyaBagley-Online

We have been aware of some of those issues and working on fixing them all across the platform incrementally.

I hope this blog might help you - https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/working-with-agol-feature-services-date-time-attributes-in-non-utc-time-zone-in-arcgis-pro-2-7/

Arcade is still an issue though. Something must have broken recently. I will remove the bullet point in section B.

Please let me know if you have any question.

Thanks

Re: Formating date fields in ArcGIS Pro Report

TanyaBagley-Online — Mon, 20 Sep 2021 16:23:01 GMT

Hello,
The issue I am having is not with the time zone it is with date field being displayed as just a number instead of a date now when exporting the report to a pdf. It used to work fine and the date field was actually a date but recently, it now shows up wrong and even though I edit the field properties to make sure it is looking at the correct feature service and the correct field. It won't export showing an actual date?
See attached image

Re: Formating date fields in ArcGIS Pro Report

TanuHoque — Mon, 20 Sep 2021 16:37:27 GMT

ah.. sorry I misunderstood. Looks like the attachment didn't come thru. Can you ple reattach?

If you add a dynamic text on a layout to show values from a date field, do you see that works?