topic How to use dateParse to return datetime in WFS in Standards and Interoperability Questions https://community.esri.com/t5/standards-and-interoperability-questions/how-to-use-dateparse-to-return-datetime-in-wfs/m-p/440655#M228 <HTML><HEAD></HEAD><BODY><SPAN>Running ArcGIS Server 10.2 and web adapter.&nbsp; Service is using an MS SQL Server 2008 R2 sp1 database table.&nbsp; AGS Service has WFS enabled.&nbsp; Get Capabilities and Filter by other fields works (e.g. &lt;ogc:PropertyIsEqualTo&gt;&lt;ogc:PropertyName&gt;Road Type&lt;/ogc:PropertyName&gt; ....... etc</SPAN><BR /><BR /><SPAN>A date field of data type: datetime called MOD_DATE is used.&nbsp; A GetCapabilities lists records with the following format date:</SPAN><BR /><SPAN>2013-05-03T00:00:00</SPAN><BR /><BR /><SPAN>Using the function dateparse returns no error but no results either.</SPAN><BR /><BR /><SPAN>What would be the correct syntax?&nbsp; Is OGC parsing of datetime available at 10.2?&nbsp; Is there a Get Capabilities syntax to return what functions AGS 10.2 can handle?</SPAN><BR /><BR /><SPAN>Thanks for any help.</SPAN></BODY></HTML> Thu, 17 Apr 2014 12:26:05 GMT JB1 2014-04-17T12:26:05Z How to use dateParse to return datetime in WFS https://community.esri.com/t5/standards-and-interoperability-questions/how-to-use-dateparse-to-return-datetime-in-wfs/m-p/440655#M228 <HTML><HEAD></HEAD><BODY><SPAN>Running ArcGIS Server 10.2 and web adapter.&nbsp; Service is using an MS SQL Server 2008 R2 sp1 database table.&nbsp; AGS Service has WFS enabled.&nbsp; Get Capabilities and Filter by other fields works (e.g. &lt;ogc:PropertyIsEqualTo&gt;&lt;ogc:PropertyName&gt;Road Type&lt;/ogc:PropertyName&gt; ....... etc</SPAN><BR /><BR /><SPAN>A date field of data type: datetime called MOD_DATE is used.&nbsp; A GetCapabilities lists records with the following format date:</SPAN><BR /><SPAN>2013-05-03T00:00:00</SPAN><BR /><BR /><SPAN>Using the function dateparse returns no error but no results either.</SPAN><BR /><BR /><SPAN>What would be the correct syntax?&nbsp; Is OGC parsing of datetime available at 10.2?&nbsp; Is there a Get Capabilities syntax to return what functions AGS 10.2 can handle?</SPAN><BR /><BR /><SPAN>Thanks for any help.</SPAN></BODY></HTML> Thu, 17 Apr 2014 12:26:05 GMT https://community.esri.com/t5/standards-and-interoperability-questions/how-to-use-dateparse-to-return-datetime-in-wfs/m-p/440655#M228 JB1 2014-04-17T12:26:05Z