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

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 

  • Created by
  • When: Tue, Feb 18 2014 1:20 PM
  • Last revision by Bentley Colleague
  • When: Fri, Sep 17 2021 11:49 AM
  • Revisions: 8
  • Comments: 0
Recommended
Related