topic Make feature layer based off last edited date in Python Questions https://community.esri.com/t5/python-questions/make-feature-layer-based-off-last-edited-date/m-p/384316#M30277 <HTML><HEAD></HEAD><BODY><P>I have editor tracking enabled on a feature class, and need to calculate some fields within a polygon that are edited each day. I currently have a script that will calculate the fields for all of the features within the polygon, but there are thousands of features and I only need to calculate the ones that were edited each day. My issue is creating a feature layer with a where clause for only today's features. What's strange is that it will work using the python window within ArcMap, but won't work as a standalone script. The layer created just contains all of the features...</P><P></P><P>arcpy.MakeFeatureLayer_management(meters, 'meter_layer', "'last_edited_date' &gt;= 'DATEADD(d, 0, DATEDIFF(d, 0, GETDATE()))'", "", "")</P><P></P><P>Any help would be greatly appreciated</P></BODY></HTML> Mon, 24 Jun 2019 20:38:47 GMT TraceStanford1 2019-06-24T20:38:47Z Make feature layer based off last edited date https://community.esri.com/t5/python-questions/make-feature-layer-based-off-last-edited-date/m-p/384316#M30277 <HTML><HEAD></HEAD><BODY><P>I have editor tracking enabled on a feature class, and need to calculate some fields within a polygon that are edited each day. I currently have a script that will calculate the fields for all of the features within the polygon, but there are thousands of features and I only need to calculate the ones that were edited each day. My issue is creating a feature layer with a where clause for only today's features. What's strange is that it will work using the python window within ArcMap, but won't work as a standalone script. The layer created just contains all of the features...</P><P></P><P>arcpy.MakeFeatureLayer_management(meters, 'meter_layer', "'last_edited_date' &gt;= 'DATEADD(d, 0, DATEDIFF(d, 0, GETDATE()))'", "", "")</P><P></P><P>Any help would be greatly appreciated</P></BODY></HTML> Mon, 24 Jun 2019 20:38:47 GMT https://community.esri.com/t5/python-questions/make-feature-layer-based-off-last-edited-date/m-p/384316#M30277 TraceStanford1 2019-06-24T20:38:47Z Re: Make feature layer based off last edited date https://community.esri.com/t5/python-questions/make-feature-layer-based-off-last-edited-date/m-p/384317#M30278 <HTML><HEAD></HEAD><BODY><P>I have had this problem as well. I make a feature layer without a definition query, then use the feature layer and use the Select by Attributes tool is where I put in the date query, then calculate field.&nbsp;</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/451331_pastedImage_1.png" /></P></BODY></HTML> Mon, 24 Jun 2019 22:21:12 GMT https://community.esri.com/t5/python-questions/make-feature-layer-based-off-last-edited-date/m-p/384317#M30278 Brian_McLeer 2019-06-24T22:21:12Z