Solved: between in where clause

Former Member · ‎2010 Feb 04

HI,

Please help me in the issue. in one of my enhancement i need the the dates between two fields . In where clause i need to have

PRSDT in between a912-datbi and a912-datab. Can anyone please suggest the how can i proceed with the query.

GauthamV · ‎2010 Feb 04

Try like this.


Select ...... 
from table
where PRSDT GE a912-datbi 
and PRSDT LE a912-datab.

Former Member · ‎2010 Feb 04

HI

user RANGES, so that u put the the upper limit and lower limit in that and u can use then in both the conditions u want.

thanx

gaurav

GauthamV · ‎2010 Feb 04

Try like this.


Select ...... 
from table
where PRSDT GE a912-datbi 
and PRSDT LE a912-datab.

between in where clause