topic Re: SFV 1.3 Query builder Widget - Date field - underlying DBMS in ArcGIS API for Flex Questions https://community.esri.com/t5/arcgis-api-for-flex-questions/sfv-1-3-query-builder-widget-date-field-underlying/m-p/266076#M6242 <HTML><HEAD></HEAD><BODY><SPAN>Hi Doug,</SPAN><BR /><BR /><SPAN>Sorry, I am not sure how I would incorporate the above code into Querybuilderwidget.mxml..</SPAN></BODY></HTML> Thu, 24 Jun 2010 19:50:25 GMT SusanMordy1 2010-06-24T19:50:25Z SFV 1.3 Query builder Widget - Date field - underlying DBMS https://community.esri.com/t5/arcgis-api-for-flex-questions/sfv-1-3-query-builder-widget-date-field-underlying/m-p/266074#M6240 <HTML><HEAD></HEAD><BODY><SPAN>Does anyone know what needs to be modified in the query builder widget code to work with Oracle SDE date fields in my map service? </SPAN><BR /><BR /><SPAN>The query Builder widget does not know what the DBMS management system is.&nbsp; What is entered into the filter box is passed to the server as a request.&nbsp; The server then passes that string to the DBMB and therefore needs to match the syntax requirements of the DBMS.&nbsp; </SPAN><BR /><BR /><SPAN>When a user double clicks an esriFieldTypeDate field in my map service, I need code that creates the date syntax that the esriFieldTypeDate field (Orcale SDE) in my map service requires.</SPAN><BR /><BR /><SPAN>Thanks for your help,</SPAN><BR /><BR /><SPAN>Susan</SPAN></BODY></HTML> Thu, 17 Jun 2010 15:52:36 GMT https://community.esri.com/t5/arcgis-api-for-flex-questions/sfv-1-3-query-builder-widget-date-field-underlying/m-p/266074#M6240 SusanMordy1 2010-06-17T15:52:36Z Re: SFV 1.3 Query builder Widget - Date field - underlying DBMS https://community.esri.com/t5/arcgis-api-for-flex-questions/sfv-1-3-query-builder-widget-date-field-underlying/m-p/266075#M6241 <HTML><HEAD></HEAD><BODY><SPAN>Try this...</SPAN><BR /><BR /><SPAN>TO_CHAR(&lt;your date field name&gt;, 'MM/DD/YYYY')</SPAN></BODY></HTML> Mon, 21 Jun 2010 19:47:09 GMT https://community.esri.com/t5/arcgis-api-for-flex-questions/sfv-1-3-query-builder-widget-date-field-underlying/m-p/266075#M6241 DouglasGuess 2010-06-21T19:47:09Z Re: SFV 1.3 Query builder Widget - Date field - underlying DBMS https://community.esri.com/t5/arcgis-api-for-flex-questions/sfv-1-3-query-builder-widget-date-field-underlying/m-p/266076#M6242 <HTML><HEAD></HEAD><BODY><SPAN>Hi Doug,</SPAN><BR /><BR /><SPAN>Sorry, I am not sure how I would incorporate the above code into Querybuilderwidget.mxml..</SPAN></BODY></HTML> Thu, 24 Jun 2010 19:50:25 GMT https://community.esri.com/t5/arcgis-api-for-flex-questions/sfv-1-3-query-builder-widget-date-field-underlying/m-p/266076#M6242 SusanMordy1 2010-06-24T19:50:25Z