# Where / Calendar Question

**URL:** <https://forums.toadworld.com/t/where-calendar-question/6429>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [December 17, 2010, 7:29pm UTC](https://forums.toadworld.com/t/where-calendar-question/6429 "2010-12-17T19:29:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![N.B](https://avatars.discourse-cdn.com/v4/letter/n/bc8723/32.png) [@N.B](https://forums.toadworld.com/u/N.B)\
**Post date:** [December 17, 2010, 7:29pm UTC](https://forums.toadworld.com/t/where-calendar-question/6429/1 "2010-12-17T19:29:13Z")

</div>

I can’t seem to get the following to work - I’m building a query in Query Builder, and one of the columns that I need to set a Where condition on is a DATE column.

But when I use Query Builder, and use the Date Range tab, I can only select an equal-to condition. This query needs to use a value of “greater than yesterday” (which I realize is somewhat odd - but it has to do with the way this table stores dates), and I can’t seem to find anyway of changing the equals-to to a greater-than when using a Gregorian Calendar on the Date Range tab.

I looked at the Customer Calendar option, but it only allows me to build a range.

I know I could also do something like “ **\> sysdate-1** ” but I’ve used the Date Range feature on the other selects that are a part of this series, and I’m not going to be maintaining them going forward, so I’m trying to make it consistent - if I can’t, that’s fine, I’m just looking to see if there’s something I’ve missed.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [December 17, 2010, 9:55pm UTC](https://forums.toadworld.com/t/where-calendar-question/6429/2 "2010-12-17T21:55:16Z")

</div>

Use the Form tab of the where condition editor. See attached.

Debbie  
 ![Dates.png](https://global.discourse-cdn.com/quest/original/2X/3/3c934eb7b385a77720fd4ea45df1db3658eb4cc7.png)
