SOLVED
Between Two Dates criteria in Visual Query Builder
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
crtakacs
8 - Asteroid
‎02-01-2020
12:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm sure this has been answered but I can't seem to find it specific to my question.
i would just like to have criteria in the Visual Query Builder that identifies between two dates.
This is what I have for it to identify date for one specific day:
= To_Date(SysDate - 2)
But I would like it to match data that is between 'SysDate - 2' and SysDate - 1'
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
1 REPLY 1
19 - Altair
‎02-01-2020
12:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @crtakacs
When you're targeting Oracle, you can use the Between operator
BETWEEN TO_DATE(SysDate-2) AND TO_DATE(SysDate-1)
Dan
