Date-time based query not working

Product(s): Bentley SewerGEMS, WaterGEMS, WaterCAD, HAMMER, StormCAD, CivilStorm, PondPack, SewerCAD
Version(s): Connect Edition, V8i
Area: Layout and Data Input


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.


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 

  • Created by
  • When:
  • Last revision by Bentley Colleague
  • When:
  • Revisions: 8
  • Comments: 0