topic Re: PROBLEM WITH MY DATE BETWEEN CLAUSE IN SELECT QUERY in Application Development and Automation Discussions

PROBLEM WITH MY DATE BETWEEN CLAUSE IN SELECT QUERY

Former Member — Sun, 17 May 2009 04:10:12 GMT

WHEN I RUN THE CODE IT'S FETCHING DATA FROM 2007,2008,2009.

SELECT ERDAT VBELN NETWR

FROM VBRK INTO CORRESPONDING FIELDS OF TABLE IT_VBRK

WHERE ERDAT BETWEEN '01.11.2008' AND '30.11.2008'.

PLEASE GIVE ME A SOLUTION GUYS.

Former Member — Sun, 17 May 2009 04:15:17 GMT

Try

SELECT ERDAT VBELN NETWR

FROM VBRK INTO CORRESPONDING FIELDS OF TABLE IT_VBRK

WHERE ERDAT BETWEEN '11.01.2008' AND '11.30.2008'.

SELECT ERDAT VBELN NETWR

FROM VBRK INTO CORRESPONDING FIELDS OF TABLE IT_VBRK

WHERE ERDAT BETWEEN '20081101' AND '20081130'.

faisalatsap — Sun, 17 May 2009 04:16:44 GMT

Hi, Zubaer,

Please Don't Use All Caps in Subject and Body Text too

Have a look at [Rules of Engagement|https://www.sdn.sap.com/irj/scn/wiki?path=/display/home/rulesofEngagement]

Under Heading
- Use a Good Subject Line
Do not use words in capital letters

Use the following way. it will solve out your Problem,

SELECT erdat vbeln netwr
FROM vbrk INTO CORRESPONDING FIELDS OF TABLE it_vbrk
WHERE erdat BETWEEN '20081101' AND '20081130'.

Best Regards,

Faisal

Former Member — Sun, 17 May 2009 05:26:27 GMT

Thank you very much.