# Working With Date Ranges in Toad Data Point

**URL:** <https://forums.toadworld.com/t/working-with-date-ranges-in-toad-data-point/43293>\
**Category:** Blog Posts\
**Created:** [November 6, 2018, 9:14am UTC](https://forums.toadworld.com/t/working-with-date-ranges-in-toad-data-point/43293 "2018-11-06T09:14:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/system/32/2_2.png) [@system](https://forums.toadworld.com/u/system)\
**Post date:** [November 6, 2018, 9:14am UTC](https://forums.toadworld.com/t/working-with-date-ranges-in-toad-data-point/43293/1 "2018-11-06T09:14:53Z")

</div>

Apr 30, 2008 12:25:00 PM by [Daniel Norwood](https://blog.toadworld.com/author/daniel-norwood)

* * *
This is a companion discussion topic for the original entry at [https://blog.toadworld.com/2008/04/30/working-with-date-ranges-in-toad-for-data-analysis](https://blog.toadworld.com/2008/04/30/working-with-date-ranges-in-toad-for-data-analysis)

---

<div class="post-metadata">

**Author:** ![frank.stumpo](https://avatars.discourse-cdn.com/v4/letter/f/838e76/32.png) [@frank.stumpo](https://forums.toadworld.com/u/frank.stumpo)\
**Post date:** [October 30, 2019, 2:10pm UTC](https://forums.toadworld.com/t/working-with-date-ranges-in-toad-data-point/43293/2 "2019-10-30T14:10:21Z")

</div>

Thanks for this information. It works perfectly running interactively in Toad Data Point. But after creating an automation I am not getting the expected results. It's seems to accept the /_Current month_/ as a comment during the automation run.

my Syntax:  
AND saw\_invoice.`date` = '' /_Current month_/

Thanks,  
Frank