Latest Contributions by LanceCole

Malcolm,  When calling a function to assign a value to an attribute in field calculator you need to pass the parameters needed in the function.  In this case, the pinning function needs to pass the datetime (FullDateTime) and the temperature (Jan26_temp) so your function call should be pinning(!FullDateTime!, !Jan26_temp!)  These will be passed to the function as the variables defined in the def statement.  In the case below, FullDateTime is assigned to dt and Jan26_temp is assigned to temp.  You then use dt and temp in your function to perform your calculations/comparisons and return a value or variable using a return statement, in this case the value of temp or -99. def pinning(dt, temp): if dt.strftime("%Y/%m/%d") == "2019/01/26": return temp else: return -99 ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Working with dates in ArcGIS is temperamental.  What I have done above is used the strftime method of a datetime class to return a string representing the date in the format of YYYY/MM/DD and compare it to the string "2019/01/26", the date you are checking. Another method you could use would be to create a datetime for 1/26/2019 and check the date portion of this value to the date portion of your FullDateTime chk = datetime.datetime(2019,1,26) def pinning(dt, tmp): if dt.date() == chk.date(): return tmp else: return -99‍‍‍‍‍‍‍‍‍‍‍‍ I hope that helps. ... View more

Malcolm,‌ You are correct on the 0-6 for weekday(), I was thinking of isoweekday() which is 1-7 for Sunday through Saturday.  Sorry about that. As you already are submitting a date type all you need is weekno = labelday.weekday() in your code to replace weekno = datetime.datetime(lableday).weekday() and you do not need the import statement. Something along the lines of the following using your naming: def typodate(lableday): weekno = lableday.weekday() if weekno < 5: return "Weekday" else: return "Weekend"‍‍‍‍‍‍ ... View more