topic Re: Logic on date in Application Development and Automation Discussions

Logic on date

Former Member — Tue, 20 Nov 2018 05:16:24 GMT

I have my internal table structure as below -

From Date | To Date | Margin

________________________

20180725 |20181116 | 2.50

20181117 |99991231 | 3.00

Based on PO creation date it should pick the margin value.

For example my PO creation date is 20180726. It should pick 2.50 as margin.

I have the code as below. But its picking 3.00 as margin. Please help.

 DATA(zyear)  = i_ekko-aedat+0(4).
 DATA(zmonth) = i_ekko-aedat+4(2).
 DATA(zdate)  = i_ekko-aedat+6(2).
 CONCATENATE zyear zmonth zdate INTO lv_podate.
 SELECT SINGLE zmargin
       FROM zsa_po_margin
       INTO @DATA(lv_po_margin)
       WHERE  zfrom_date >= @lv_podate AND
              zto_date   <= @lv_podate .
<br>

Re: Logic on date

RaymondGiuseppi — Tue, 20 Nov 2018 07:24:28 GMT

Your code look for a record where from date is greater than a date and to date lower, some kind of reversed logic or a typo?

Re: Logic on date

DoanManhQuynh — Tue, 20 Nov 2018 08:51:49 GMT

lv_podate much be between zfrom_date and zto_date but your sql conditions is not correct. and why you have to concatenate the date, just lets it asis.

 SELECT SINGLE zmargin
 FROM zsa_po_margin
 INTO @DATA(lv_po_margin)
 WHERE zfrom_date <= @i_ekko-aedat AND
         zto_date >= @i_ekko-aedat .