AnsweredAssumed Answered

Concatenate Date and Time in a date field

Question asked by ahmadabusaleh on Aug 27, 2018
Latest reply on Aug 30, 2018 by ahmadabusaleh

Hello,

I Have 3 dates fields as the image below:

What I am trying to do is to populate 'Created' and 'Updated' fields with values from  'Designdate' field  and  add time to this field.

The time value will be static and doesn't change ( 12:01:00 AM) the result should be something like this "1/1/2015 12:01:00 AM".

Till now I couldn't  figure out how to do this using python ,  what I have so far is the below script but this will populate the fields with  dates only without the time. Any Ideas?. 

import datetime
import arcpy


targetfc=r"D:\d2\New File Geodatabase.gdb\gf"
updateDateFields=['created','updated','DesignDate']
time='12:01:00 AM'

with arcpy.da.UpdateCursor(targetfc, updateDateFields) as userUpdateCursor2:
          for row in userUpdateCursor2:
             row[0]=row[2]
             row[1]=row[2]
             userUpdateCursor2.updateRow(row)
         



del userUpdateCursor2

 

Thank you,

Outcomes