https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-field-with-functions-amp-values-from/m-p/1397422#M9777 <P>I'm sure I'm missing something simple.&nbsp; I am just trying to use the API for python to update attributes using functions and values from other fields; but haven't been successful in formatting the the statement correct.</P><LI-CODE lang="python">def getTotalDays(load,start): delta = load-start days = delta.days if days ==0: return 1 else: return days calc_dict['field'] = 'totaldays' #This is not correct: calc_dict['sqlExpression'] = 'getTotalDays(!{0}!,!{1}!)'.format("dateloadedenterprise","surveydatestart") result = compliance_svc_lyr.calculate(where=where,calc_expression=calc_dict)</LI-CODE><P>Additionally, I previously used dataframes to update the service, however had the same error as noted <A href="https://community.esri.com/t5/arcgis-api-for-python-questions/issue-with-datetime-field-after-converting/td-p/1373700" target="_self">in this post</A>, so I'm resorting back to field calculations.</P> Mon, 18 Mar 2024 17:58:42 GMT usace_sam_rd3 2024-03-18T17:58:42Z https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-field-with-functions-amp-values-from/m-p/1397422#M9777 <P>I'm sure I'm missing something simple.&nbsp; I am just trying to use the API for python to update attributes using functions and values from other fields; but haven't been successful in formatting the the statement correct.</P><LI-CODE lang="python">def getTotalDays(load,start): delta = load-start days = delta.days if days ==0: return 1 else: return days calc_dict['field'] = 'totaldays' #This is not correct: calc_dict['sqlExpression'] = 'getTotalDays(!{0}!,!{1}!)'.format("dateloadedenterprise","surveydatestart") result = compliance_svc_lyr.calculate(where=where,calc_expression=calc_dict)</LI-CODE><P>Additionally, I previously used dataframes to update the service, however had the same error as noted <A href="https://community.esri.com/t5/arcgis-api-for-python-questions/issue-with-datetime-field-after-converting/td-p/1373700" target="_self">in this post</A>, so I'm resorting back to field calculations.</P> Mon, 18 Mar 2024 17:58:42 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-field-with-functions-amp-values-from/m-p/1397422#M9777 usace_sam_rd3 2024-03-18T17:58:42Z