Strange behavior with Date Field Bulk Calculation in Arcgis Pro.

Question

With a date field set with DD/MM/YYYY format, in filegeodatabase, if I insert the date via calendar there is no problem, while if I calculate it via Calculate of PRO with a date > day 12, it inserts the date correctly; while if the date has a day less than twelve, it inserts the date in the MM/DD/YYYY format. Has anyone ever encountered this problem? And how did you solve it without having to force the calculation with Python every time?

JoshuaBixby · Answer

It would be helpful to share a specific example of text and code and the result.  I can't say I completely understand the steps you are taking, so I can't offer any specific feedback.

SITRAVENNA · Answer

no difference between pc local data and PRO. Will continue to use python expressions to avoid errors.

Thank Dan.

danretired · Answer

Is there a difference in your locale's date setup on your computer vs what Pro uses?

Are you using a specific option to calculate dates in the field calculator?  Look at some of the examples

Calculate Field Python examples—ArcGIS Pro | Documentation