topic Re: how to retrive data between two dates in Application Development and Automation Discussions

how to retrive data between two dates

Former Member — Mon, 01 Dec 2008 12:35:30 GMT

Hi Guru's

i want to retrive data between two finish date and start date.

i write following code but this code work not properly.

select gltrp gstrp aufnr from afko into corresponding fields of table

itab1 where aufnr in orderno and gstrp in FINISHDT

and gltrp in STARTDT.

please suggest me.

Regard

sam.

Re: how to retrive data between two dates

Former Member — Mon, 01 Dec 2008 12:37:34 GMT

Hello,

begda -> begin date.

endda -> enddate.

where begda <= sy-datum

and endda >= sy-datum.

Above statement will fetch the data valid today.

Hope it helps.

Thanks,

Jayant

Re: how to retrive data between two dates

rainer_hbenthal — Mon, 01 Dec 2008 12:39:07 GMT

As you didnt tell how the two ranges table are filled no one can help you. I would suggest to take less then and reater then instead range tables.

Re: how to retrive data between two dates

Former Member — Mon, 01 Dec 2008 12:40:22 GMT

Use BETWEEN in the WHERE clause

Hope this will solve your problem

Regards

Ramchander Rao.K

Re: how to retrive data between two dates

Former Member — Mon, 01 Dec 2008 12:40:37 GMT

Hi Sam

Do it like this:

and make sure you are also including date field in the selection and you ca ngive the date range in select option.

select gltrp gstrp aufnr gstrp from afko into corresponding fields of table

itab1 where aufnr in orderno and gstrp eq p_start and gltrp eq p_finish.

Regards

Neha

Edited by: Neha Shukla on Dec 1, 2008 6:12 PM

Re: how to retrive data between two dates

Former Member — Mon, 01 Dec 2008 13:31:19 GMT

first u get first and last date useing following FM

'FIRST_AND_LAST_DAY_IN_YEAR_GET'

Re: how to retrive data between two dates

Former Member — Mon, 01 Dec 2008 13:33:21 GMT

select gltrp gstrp aufnr from afko into corresponding fields of table

itab1 where aufnr in orderno and (gstrp >= STARTD and gstrp <= FINISHDT).

Regards,

Ajay

Re: how to retrive data between two dates

Former Member — Mon, 01 Dec 2008 13:36:39 GMT

Hi Sam,

Use BETWEEN in WHERE clause of your SELECT query.

select gltrp gstrp aufnr from afko into corresponding fields of table
itab1 where aufnr in orderno and gstrp between STARTDT and FINISHDT.

With luck,

Pritam.