topic Re: data fetching comparing dates. in Application Development and Automation Discussions

data fetching comparing dates.

Former Member — Thu, 06 Aug 2009 09:20:17 GMT

there are 2 fields in the table

Beginging and End date

for every employee there r two or more rows.

In my selection screen i m selecting month and year.i want to fetch only that row for a employee which comes in date range.

for example

selection screen

month 05

year 2009

beg end

04/2008 09/2008

10/2008 09/2009

so it shud select the second row.

thanks.

Edited by: aks on Aug 6, 2009 5:25 AM

Re: data fetching comparing dates.

Former Member — Thu, 06 Aug 2009 09:29:46 GMT

Hi,

you can put logic in the following way...

SELECT SINGLE exmpt FROM t5u13

INTO t5u13-exmpt

WHERE stell = p0001-stell AND

begda <= p_prcdte AND

endda >= p_prcdte.

Thanks

Ashu

Re: data fetching comparing dates.

viquar_iqbal — Thu, 06 Aug 2009 09:33:31 GMT

Use offsets.

READ TABLE itab WITH TABLE KEY beg4(4) <= year end4(4) >= year.

If sy-subrc eq 0.

display record.

endif.

Hope this resolves your query.

Viquar Iqbal

Re: data fetching comparing dates.

Former Member — Thu, 06 Aug 2009 09:38:28 GMT

thank u...

Re: data fetching comparing dates.

Former Member — Thu, 06 Aug 2009 09:41:35 GMT

Hi,

Well one way of doing it is concatenate the month and year and pass it to the select statement.



data: dat(6) type c.

concatenate year month into date.

select * 
from Dbtable 
into itab
where begda <= date and 
        endda >= date.

Regards,

Vik

Re: data fetching comparing dates.

Former Member — Thu, 06 Aug 2009 09:45:22 GMT

Hi Friend ,

**************************if it is a date***********************

1. Using that month and year get the first date and last date of the month .

2. Create range field for date .

3. Populate the begi date in low value and ending date in high value.

4. In you select query

select <fields>

from <table>

into <itab>

where beg <= rang_date-low and

end >= rang_date-high.

********************************if it is a period ********************************************************

1. Concatenate the month and year .

2. select query

select <fields>

from <table>

into <itab>

where beg <= Period and

end >= period .

thanks,

Re: data fetching comparing dates.

Former Member — Thu, 13 Aug 2009 11:14:19 GMT

READ TABLE itab WITH TABLE KEY beg4(4) <= year end4(4) >= year.

reln. operator <= not working pls help...

Re: data fetching comparing dates.

Former Member — Thu, 13 Aug 2009 11:25:32 GMT

Hi,

The relational operator <= wont work for read statement. This is the easy way to do it



data: date(6) type c.
 
concatenate p_year p_month into date.
 
select * 
from Dbtable 
into itab
where begda <= date and 
        endda >= date.

The relational operator can be used with IF condition. Not read statements.

Regards,

Vik

Re: data fetching comparing dates.

Former Member — Thu, 13 Aug 2009 11:25:47 GMT

but wat if i want to compare year from the date beg+4(4) <= year

Re: data fetching comparing dates.

Former Member — Thu, 13 Aug 2009 11:30:25 GMT

Then use the if condition instead of read



loop at itab.
if itab-beg+4(4) <= year itab-end+4(4) >= year.
display record.
endif.
endloop.

Regards,

Vik