topic CURRENT_DATE function on ArcSDE SQL Server Database not working in Data Management Questions https://community.esri.com/t5/data-management-questions/current-date-function-on-arcsde-sql-server/m-p/638374#M36107 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/legacyfs/online/57973_SDE_CURRENT_DATE.PNG"><IMG alt="SDE_CURRENT_DATE.PNG" class="image-1 jive-image" height="881" src="https://community.esri.com/legacyfs/online/57973_SDE_CURRENT_DATE.PNG" style="width: 620px; height: 509px;" width="1074" /></A>I am writing a script to access data from each day. I would like to select by attribute and send these features to a local file geodatabase. After reading some documenation, CURRENT_DATE is the function which reads data for today. This is an example of my data '2015-02-02 00:00:00'. I don't have the time for any features, so in reality it is only YYYY-MM-DD. In a local file geodatabase, the query PlannedDate = CURRENT_DATE works. However in my ArcSDE SQL Server connection it does not. PlannedDate = GETDATE () does not work either, however no errors are being returned.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>The data is my table is m/d/yyyy The data when selecting by attribute is yyyy-mm-dd.</P></BODY></HTML> Mon, 02 Feb 2015 18:30:19 GMT GeoffreyWest 2015-02-02T18:30:19Z CURRENT_DATE function on ArcSDE SQL Server Database not working https://community.esri.com/t5/data-management-questions/current-date-function-on-arcsde-sql-server/m-p/638374#M36107 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/legacyfs/online/57973_SDE_CURRENT_DATE.PNG"><IMG alt="SDE_CURRENT_DATE.PNG" class="image-1 jive-image" height="881" src="https://community.esri.com/legacyfs/online/57973_SDE_CURRENT_DATE.PNG" style="width: 620px; height: 509px;" width="1074" /></A>I am writing a script to access data from each day. I would like to select by attribute and send these features to a local file geodatabase. After reading some documenation, CURRENT_DATE is the function which reads data for today. This is an example of my data '2015-02-02 00:00:00'. I don't have the time for any features, so in reality it is only YYYY-MM-DD. In a local file geodatabase, the query PlannedDate = CURRENT_DATE works. However in my ArcSDE SQL Server connection it does not. PlannedDate = GETDATE () does not work either, however no errors are being returned.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>The data is my table is m/d/yyyy The data when selecting by attribute is yyyy-mm-dd.</P></BODY></HTML> Mon, 02 Feb 2015 18:30:19 GMT https://community.esri.com/t5/data-management-questions/current-date-function-on-arcsde-sql-server/m-p/638374#M36107 GeoffreyWest 2015-02-02T18:30:19Z Re: CURRENT_DATE function on ArcSDE SQL Server Database not working https://community.esri.com/t5/data-management-questions/current-date-function-on-arcsde-sql-server/m-p/638375#M36108 <HTML><HEAD></HEAD><BODY><P>Figured it out, PlannedDate = CONVERT(DATE, GETDATE())</P></BODY></HTML> Mon, 02 Feb 2015 18:46:53 GMT https://community.esri.com/t5/data-management-questions/current-date-function-on-arcsde-sql-server/m-p/638375#M36108 GeoffreyWest 2015-02-02T18:46:53Z