topic Re: help reqd in Application Development and Automation Discussions

help reqd

Former Member — Tue, 24 Jul 2007 09:44:11 GMT

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.

Re: help reqd

Former Member — Tue, 24 Jul 2007 09:47:18 GMT

Hello,

Use the S_date like this.

select * from table into table itab where date in S_DATE

Vasanth

Re: help reqd

Former Member — Tue, 24 Jul 2007 09:53:11 GMT

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

Re: help reqd

kesavadas_thekkillath — Tue, 24 Jul 2007 10:37:59 GMT

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.

Re: help reqd

Former Member — Tue, 24 Jul 2007 10:41:53 GMT

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.

Re: help reqd

kesavadas_thekkillath — Tue, 24 Jul 2007 10:43:55 GMT

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.