Hello
I have a oracle database 11g, Im Trying to build a query to pull all records that will expire between today and within 30 days.
This is my statement and is only pulling records that will expire in 30. How can I add a between Now and 30 days? Please help.
LV.DATETERM < to_char(current_date,'YYYYMMDD')+30
| Name: | DateTerm |
| Database Column: | DateTerm |
| Database Table Name: | LicenseVer |
| Value Type: | INT |
| Required: | False |
| Field Type: | Standard |