Product(s): |
Bentley SewerGEMS, WaterGEMS, WaterCAD, HAMMER, StormCAD, CivilStorm, PondPack, SewerCAD |
Version(s): |
Connect Edition, V8i |
Area: |
Layout and Data Input |
Problem
After validating or computing a date/time type query your results return all elements (ex. 21 of 21 elements returned) when you know there should be fewer than this.
Solution
The SQL language requires that you put a # sign (a pound sign) both in front and behind the date when performing a query on this type of data value.
See Also
Query not returning results for fields that use a pick-list