Calculate Date Field.

jaykapalczynski

I am trying to calculate a date/time field in Python with not much luck...

In ArcGIS I am doing this with a calculate and it calculates fine...its going into a Date Field.

(Right("00" & [Hour],2) + ":" + Right("00" & [Minute],2))

result:  4:02:00 PM

I want to do this in Python and am trying this after reading in a CSV File.  No error but no result in the feature class created.

If I dont get the syntax correct it tells me "Right" is not defined

Hour = str(lineSplit[3])
Minute = str(lineSplit[4])

CalcDate1 = "Right('00' & Hour,2) & ':' & Right('00' & Minute,2)"
print CalcDate1

It gives me this in the results window in the shell:

Right('00' & Hour,2) & ':' & Right('00' & Minute,2)

jaykapalczynski

Mitch Holley, Darren Wiens THANK YOU FOR YOUR HELP AND SUPPORT....Things are running great...although not the most efficient way but I got it...with YOUR help of course

ANY QUESTIONS:  please feel free to reply and I will get back with you..

THANKS Again Mitch and Darren....SOOOO very much appreciated.

1. Read CSV to file to get all records

2. I calculated the Time field (CalcTime) from an Hour and Minute Field..

         12:02:00 AM

3. Once I had that I calculated the Full CalcDateTime field from CalcTime above and the Date field from the CSV

          6/29/2016 12:02:00 AM 

4. Inserted ROWS into the Feature Class using SHAPE@XY Token to create the geometry

Hour Minute from CSV File

 0          2

getTime3 Variable - CalcTime Field Result in New Feature Class
12:02:00 AM

getDateTime Variable - CalcDateTime field result in the New Feature Class concatenated with the Date field from the CSV File

6/29/2016 12:02:00 AM

FULL CODE BELOW

import arcpy
import datetime

def getdate(Hour, Minute):
return datetime.datetime.strptime(str(Hour).zfill(2) + ' ' + str(Minute).zfill(2), '%H %M')

fc = r'C:\Users\\Collar\BearLocationImports.gdb\BearCollar'

cursor = arcpy.da.InsertCursor (fc,["CollarSeri", "Year", "Julianday", "Hour", "Minute", "Activity", "Temperatur", "Latitude", "Longitude", "HDOP", "NumSats", "FixTime", "Date", "_2D_3D", "BearID", "CalcDate", "CalcDate3", "SHAPE@XY"])

for ln in open (r"C:\Users\tjv36463\Desktop\Bear Collar\rangedate_D032495_20160822124736_NH.txt", 'r').readlines():

#Each line in the csv is a string, so turn it into a list so you can reference each column
lineSplit = ln.split(",")

#Use index positions to get the right column from the csv
#Make sure the data is the correct type (i.e. X and Y need to be numbers, not strings)
CollarSeri = long(lineSplit[0])
Year = str(lineSplit[1])
Julianday = str(lineSplit[2])
Hour = int(lineSplit[3])
Minute = int(lineSplit[4])
Activity = int(lineSplit[5])
Temperature = int(lineSplit[6])
Latitude = float(lineSplit[7])
Longitude = float(lineSplit[8])
HDOP = str(lineSplit[9])
NumSats = int(lineSplit[10])
FixTime = int(lineSplit[11])
_2D_3D = int(lineSplit[12])

BearID = 0

Date = str(lineSplit[13]) # working with Date Time http://stackoverflow.com/questions/1521906/how-to-specify-date-and-time-in-python

getTime = getdate(Hour, Minute)
getTime2 = str(getTime)
getTime3 = getTime2[-8:]

getDateTime = (Date + getTime3)
print getDateTime

shapeVal = (Longitude, Latitude)

#Insert the values from csv into feature class
cursor.insertRow ([CollarSeri, Year, Julianday, Hour, Minute, Activity, Temperature, Latitude, Longitude, HDOP, NumSats, FixTime, Date, _2D_3D, BearID, getTime3, getDateTime, shapeVal])

count += 1

del cursor
print ("done")