https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-number-of-days-in-date-attribute/m-p/1271934#M8555 <P>If you can load your data into a <STRONG>pandas </STRONG>DataFrame (a "GeoAccessor" in the Python API), it's simple:</P><LI-CODE lang="python">from arcgis.features import GeoAccessor # load layer into dataframe df = GeoAccessor.from_featureclass('path/to/fc') # create new date field, dropping time df['the_date'] = df['your_datetime_field'].dt.date # get the count df.groupby('the_date').count()</LI-CODE><P>&nbsp;</P> Mon, 27 Mar 2023 15:02:10 GMT jcarlson 2023-03-27T15:02:10Z https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-number-of-days-in-date-attribute/m-p/1271927#M8553 <P>I have a dataset that contains a date attribute and records show date/time. How can I count then number of unique dates while disregarding the time stamp?&nbsp;</P> Mon, 27 Mar 2023 14:52:49 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-number-of-days-in-date-attribute/m-p/1271927#M8553 avonmoos 2023-03-27T14:52:49Z https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-number-of-days-in-date-attribute/m-p/1271934#M8555 <P>If you can load your data into a <STRONG>pandas </STRONG>DataFrame (a "GeoAccessor" in the Python API), it's simple:</P><LI-CODE lang="python">from arcgis.features import GeoAccessor # load layer into dataframe df = GeoAccessor.from_featureclass('path/to/fc') # create new date field, dropping time df['the_date'] = df['your_datetime_field'].dt.date # get the count df.groupby('the_date').count()</LI-CODE><P>&nbsp;</P> Mon, 27 Mar 2023 15:02:10 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/calculate-number-of-days-in-date-attribute/m-p/1271934#M8555 jcarlson 2023-03-27T15:02:10Z