laptop and a wrench

Bug

When converting a string to an international date format with ArcGIS Pro's GeoAnalytics Desktop Tools' Calculate Field with Arcade, it rounds down the output day by one.

ArcGIS Pro
Bug ID Number BUG-000166416
SubmittedApril 1, 2024
Last ModifiedMarch 19, 2025
Applies toArcGIS Pro
Version found3.2.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusAs Designed

Additional Information

With the conversion of time to UTC, this is an expected result. It's not rounding down but instead converting to UTC, which shifts the time a few hours based on the time zone.

Workaround

The issue is not reproducible with USA Date/Time fields (mm/dd/yyyy).

Steps to Reproduce

Bug ID: BUG-000166416

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options