Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

PROBLEM WITH MY DATE BETWEEN CLAUSE IN SELECT QUERY

Former Member

‎2009 May 17 5:10 AM

0 Likes
518

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.

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.

Reply
3 REPLIES 3
Read only

Former Member

‎2009 May 17 5:15 AM

0 Likes
495

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'.

Read only

Former Member
In response to Former Member

‎2009 May 17 6:26 AM

0 Likes
495

Thank you very much.

Read only

faisalatsap
Active Contributor

‎2009 May 17 5:16 AM

0 Likes
495

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