02-10-2007 5:28 AM
Hi All,
I want to find whether the system date falls between from_date and to_date fields of a table. Pls help me.
Thank you,
praveena
02-10-2007 5:46 AM
one option is
<b>CSCP_PARA1_GET_PERIODS
I_DATUV 01.02.2005
I_DATUB 31.12.2010
I_TIMEUNIT D
Tables Value
ET_DATES 0 Entries
Result: 2,161 Entries</b>
after that check this table with current date.
Regards
Prabhu
02-10-2007 7:49 AM
select * from xxx into table itab where sy-datum ge from_date and sy_datum eq le todate .
Raja