I have a project where feature areas have a start/end date. Trying to add a filter for the Start Date say > 1/12/2011 show no entries.
Similarly, trying to setup thematic maps based on a date only work for the = operator. For instance, determining which areas are under construction at a specific date. Where StartDate <= 1/1/2012 and Where EndDate >= 1/1/2012 do not change any symbology. Checking for StartDate = 04/16/2011 does show the symbology correctly for that Work Area. Is there something I'm missing? Thanks.
Bentley Map V8i (SELECTseries 1) 08.11.07.87
I have tried this with another dataset, so the data is not the same, etc. and have no issues with it. Mybe you need to change the >= to => , etc. to make it work.
...agreed with Jerry that the date filtering seems to work with other data sets as seen in the following:
...so I wonder if the property type in your feature class definition is being seen as "string" or "date" type which would provide different filtering methods (click on the filter icon to show the options) as shown in the following images:
Regards,
Jeff Bielefeld [Bentley]
I do get the correct pull downs for the filter:
Perhaps, the field itself is created incorrectly?
I created a DateTime Property and set the type to Date4:
Bryan
...was able to reproduce what you are seeing when using a non-RDBMS type property. Please attempt the following and let me know if you are able to filter your date properties as expected.
Let me know if this works for you and I will continue investigation on underlying potential problem.
Filtering based on dates now works after changing the Type to dateticks
Thanks,