topic Re: Problem with date Query in ArcGIS API for Flex Questions

Problem with date Query

Yusufalbanki — Thu, 05 Apr 2012 16:18:56 GMT

Hi All,

I have a query that should return records according to selected duration. I did it but it return strange records.

my function :

protected function button1_clickHandler(event:MouseEvent):void
   {

    datetimeFormatter.dateTimePattern="yyyy-MM-dd HH:mm:ss";

    var strFromDate:String=datetimeFormatter.format(dfFrom.selectedDate);

    var strToDate:String=datetimeFormatter.format(dfTo.selectedDate);

    getIncidentsParam.where="Inc_AlarmTime > date '"+strFromDate+"' AND Inc_AlarmTime < date '"+strToDate+"'";

    getIncidents.execute(getIncidentsParam);
   }

I read the date from datefield.

The returned records sometimes before the duration like attached snapshot[ATTACH=CONFIG]13276[/ATTACH]

Is there solution for this problem.

Thanks
Yusuf

Re: Problem with date Query

RobertScheitlin__GISP — Thu, 05 Apr 2012 16:35:23 GMT

Yusuf,

I spent a good deal of time with esri tech support on date range search issue and basically this is what I got to work:

FeatLay.timeDefinition = new TimeExtent(DatePicker1.selectedDate,DatePicker2.selectedDate);

Apply a time extent to a actual featurelayer.

We never got a great than or equal to and a less than or equal to query to work in a where clause.

Don't forget to click the Mark as answer check on this post and to click the top arrow (promote) as shown below:

Re: Problem with date Query

Yusufalbanki — Thu, 05 Apr 2012 16:52:06 GMT

Thank you very much Robert for your reply.

Re: Problem with date Query

DasaPaddock — Thu, 05 Apr 2012 20:06:25 GMT

Also see:
http://help.arcgis.com/en/webapi/flex/apiref/com/esri/ags/tasks/supportClasses/Query.html#timeExtent