https://community.esri.com/t5/python-questions/field-of-type-date-being-interpreted-as-a-string/m-p/1485133#M70721 <P>In field calculator your python expression would be something like:<BR /><BR /></P><LI-CODE lang="python">int(str(datetime.today() - !LastInsp!).split(" ")[0])</LI-CODE> Wed, 05 Jun 2024 09:21:22 GMT RichardHowe 2024-06-05T09:21:22Z https://community.esri.com/t5/python-questions/field-of-type-date-being-interpreted-as-a-string/m-p/1484719#M70718 <P>I have a feature class in which I'm trying to calculate the number of days between now, and when a property was last inspected. However, when I try to use the variable for the last inspection date Python/arcgis seems to think LastInsp is a string - but its a date field. I'm baffled, I use a hosted version of this featureclass, and use Arcade to calculate this value using this approach which works fine.</P><LI-CODE lang="javascript">var last_date = $feature.LastInsp; var now = Today(); var DaysSince = round(DateDiff(now,last_date,'days'))</LI-CODE><P>&nbsp;</P> Tue, 04 Jun 2024 19:44:49 GMT https://community.esri.com/t5/python-questions/field-of-type-date-being-interpreted-as-a-string/m-p/1484719#M70718 clt_cabq 2024-06-04T19:44:49Z https://community.esri.com/t5/python-questions/field-of-type-date-being-interpreted-as-a-string/m-p/1485133#M70721 <P>In field calculator your python expression would be something like:<BR /><BR /></P><LI-CODE lang="python">int(str(datetime.today() - !LastInsp!).split(" ")[0])</LI-CODE> Wed, 05 Jun 2024 09:21:22 GMT https://community.esri.com/t5/python-questions/field-of-type-date-being-interpreted-as-a-string/m-p/1485133#M70721 RichardHowe 2024-06-05T09:21:22Z