https://community.sap.com/t5/application-development-and-automation-discussions/between-in-where-clause/m-p/6553171#M1429991 <HTML><HEAD></HEAD><BODY><P>HI</P><P>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.</P><P></P><P>thanx</P><P>gaurav</P></BODY></HTML> Thu, 04 Feb 2010 07:40:29 GMT Former Member 2010-02-04T07:40:29Z https://community.sap.com/t5/application-development-and-automation-discussions/between-in-where-clause/m-p/6553170#M1429990 <HTML><HEAD></HEAD><BODY><P>HI,</P><P> 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 </P><P></P><P> PRSDT in between a912-datbi and a912-datab. Can anyone please suggest the how can i proceed with the query.</P></BODY></HTML> Thu, 04 Feb 2010 07:19:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/between-in-where-clause/m-p/6553170#M1429990 Former Member 2010-02-04T07:19:24Z https://community.sap.com/t5/application-development-and-automation-discussions/between-in-where-clause/m-p/6553171#M1429991 <HTML><HEAD></HEAD><BODY><P>HI</P><P>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.</P><P></P><P>thanx</P><P>gaurav</P></BODY></HTML> Thu, 04 Feb 2010 07:40:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/between-in-where-clause/m-p/6553171#M1429991 Former Member 2010-02-04T07:40:29Z https://community.sap.com/t5/application-development-and-automation-discussions/between-in-where-clause/m-p/6553172#M1429992 <HTML><HEAD></HEAD><BODY><P>Try like this.</P><P></P><PRE><CODE> Select ...... from table where PRSDT GE a912-datbi and PRSDT LE a912-datab. </CODE></PRE><P></P></BODY></HTML> Thu, 04 Feb 2010 07:44:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/between-in-where-clause/m-p/6553172#M1429992 GauthamV 2010-02-04T07:44:14Z