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
The data browser now filters the dates correctly:
However, I seem to have a similar problem on the themes.
Would appreciate any more suggestions.
Bryan
Filtering based on dates now works after changing the Type to dateticks
Thanks,
...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.
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:
...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: