skip certain fields

Question

I am able to run a script that will calculate the time spent onsite using the datetime field for our service in and out times.  The issue is the script stops (error) when it encounters a datetime field with no time in it (working on making sure that doesn't happen).  I am wondering if there is a quick python addition I can add that when it encounters a datetime field with no time, it will skip over that record and keep running through the records.  The records are a large amount and this is getting time consuming to keep starting the script at the next record after it error'd out on a record with no time in the field.  I've attached a screenshot of an example.

Thanks!

script.jpg

curtvprice · Answer

In answer to your original question:

I am wondering if there is a quick python addition I can add that when it encounters a datetime field with no time, it will skip over that record and keep running through the records.

def fnElapsed(STRDTTM, ENDDTTM): 
  from datetime import datetime
  try:
    dateStart = datetime.strptime(STRDTTM, "%m/%d/%Y %I:%M:%S %p") 
    dateEnd = datetime.strptime(ENDDTTM, "%m/%d/%Y %I:%M:%S %p") 
    timeDiff = dateEnd - dateStart 
    elapMin = timeDiff.total_seconds()/60 
    return elapMin
  except:
    pass

PeterWilson · Answer

Hi Chad

The following will deal with the blanks within your date fields:

def fnElapsed(STRDTTM, ENDDTTM):
  from datetime import datetime
  try:
    dateStart  = datetime.strptime(STRDTTM, "%d/%m/%Y %I:%M:%S %p")
    dateEnd = datetime.strptime(ENDDTTM, "%d/%m/%Y %I:%M:%S %p")
    timeDiff = dateEnd - dateStart
    elapMin = timeDiff.total_seconds()/60
    return elapMin
  except Exception as inst:
    print type(inst)

fnElapsed(!STRDTTM!, !ENDDTTM!)

DarrenWiens2 · Answer

Similar to above, you can return a dummy value instead of changing the datetime format to flag your records.

from datetime import datetime
def fnElapsed(STRDTTM, ENDDTTM):
  try:
    dateStart = datetime.strptime(STRDTTM, "%d/%m/%Y %I:%M:%S %p")
  except:
    return 9999
  try:
    dateEnd = datetime.strptime(ENDDTTM, "%d/%m/%Y %I:%M:%S %p")
  except:
    return -9999
  timeDiff = dateEnd - dateStart
  return timeDiff.total_seconds()/60