Skip to Content
0
Former Member
Sep 17, 2007 at 01:21 PM

select with < for all entries in> clause for date range selection

342 Views

Hi ,

I have a select with < for all entries in> clause and i need to get all the values

in the date range . so i declared r_date as range and added in the end of the select using IN Clause...Is that correct or Am I using the wrong declaration,

Is there any other way to define the date ranges in the select?

r_date declaration with RANGES

  • Date range for the Previous month

r_date-sign = 'I'.

r_date-option = 'BT'.

r_date-low = w_strt_date.

r_date-high = w_end_date.

append r_date.

Select statement:

select <Field names> from <Tabname> into table <Internal Table>

for all entries in t_Keys_POI

where DOC_NUM = t_Keys_POI-DOC_NUM

and DOC_ITEM = t_Keys_POI-DOC_ITEM

and LOGSYS = t_Keys_POI-LOGSYS

and REC_TYPE = 1

and DOC_DATE IN r_date..

Thanks,

Mike