https://community.esri.com/t5/arcgis-online-questions/change-time-in-datetime-field-using-arcade-or-sql/m-p/1313849#M53675 <P>I have a field with thousands of dates formatted like this: 11/12/2000 7:30:00 PM. I need to convert the time in each to 12:00:00 PM while leaving the date unchanged.</P><P>&nbsp;</P><P>I can do this using Python like:&nbsp;!DateField!.replace(hour=12, minute=0, second=0). ArcGIS Online limits calculations to only Arcade or SQL.&nbsp;</P><P>How can I change the times in AGOL?</P> Mon, 31 Jul 2023 20:27:21 GMT GISAdmin7 2023-07-31T20:27:21Z https://community.esri.com/t5/arcgis-online-questions/change-time-in-datetime-field-using-arcade-or-sql/m-p/1313849#M53675 <P>I have a field with thousands of dates formatted like this: 11/12/2000 7:30:00 PM. I need to convert the time in each to 12:00:00 PM while leaving the date unchanged.</P><P>&nbsp;</P><P>I can do this using Python like:&nbsp;!DateField!.replace(hour=12, minute=0, second=0). ArcGIS Online limits calculations to only Arcade or SQL.&nbsp;</P><P>How can I change the times in AGOL?</P> Mon, 31 Jul 2023 20:27:21 GMT https://community.esri.com/t5/arcgis-online-questions/change-time-in-datetime-field-using-arcade-or-sql/m-p/1313849#M53675 GISAdmin7 2023-07-31T20:27:21Z https://community.esri.com/t5/arcgis-online-questions/change-time-in-datetime-field-using-arcade-or-sql/m-p/1313983#M53681 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/53861">@GISAdmin7</a>&nbsp;,</P><P>Do you have access to ArcGIS Pro?&nbsp; If so, you can add the feature service and use the python expression you have above in the Calculate Field tool.</P> Tue, 01 Aug 2023 11:28:14 GMT https://community.esri.com/t5/arcgis-online-questions/change-time-in-datetime-field-using-arcade-or-sql/m-p/1313983#M53681 JakeSkinner 2023-08-01T11:28:14Z