help reqd

[Former Member]

hi,

i have a selection screen with select-options of date.

if fromdate and todate .

i will specify the selection period as fromdate and todate.

elseif fromdate.

i will specify the selection period as fromdate alone.

elseif todate.

i must specify what.. it will select records upto the todate.

elseif no fromdate and no todate.

i must specify what..bcos it will select all recorrds without any condition.

endif.

i must tell the selection period.. for the last two case s wat can i tell.. pls hurry up.. will be rewarded.. thankx in adv.

[Former Member]

Hello,

Use the S_date like this.

select * from table into table itab where date in S_DATE

Vasanth

[Former Member]

hi... i wanted to show it in the report....

the selection period.

i cant show like

00/00/0000 to 00/00/0000 right..

i want some soln for that..

pls help

[kesavadas_thekkillath]

for the first case select the minimum date from table and show it as low

for the second case select the minimum date and maximum date from the table for that field and display...

I guess this is u r question.....

reward if useful.

[Former Member]

Hi Evangeline,

You can declare a variable lv_date as string.

IF FROMDATE and TODATE.

Concatenate the date fields into the local variables along with the seperator

ELSEIF FROMDATE

Concatenate only FROMDATE to the variable

ELSEIF TODATE

Concatenate only TODATE to the variable

ELSEIF NODATE

DO not specify any date

ENDIF.

<i><b>Reward points for useful answers.</b></i>

Best Regards,

Ram.

[kesavadas_thekkillath]

if from date is initial and two date is not initial.

This condition u an block through validation by compulsorily making enter the from date.

dono allow the from date to be null.

If both are null

select the max and min date from the table.