查询日期条件-CSDN博客

本文链接：https://blog.csdn.net/qyshaka/article/details/143807589

RANGES: s_ersda FOR mara-ersda.
RANGES: s_laeda FOR mara-laeda.

**********************************************************************
* 获取日期
**********************************************************************
  " 第一种情况：开始日期和结束日期都为空。
*  IF p_startdate IS INITIAL AND p_enddate IS INITIAL.
*  ENDIF.

  " 第二种情况：开始日期不为空，结束日期为空
  IF p_startdate IS NOT INITIAL AND p_enddate IS INITIAL.
    s_ersda-sign   = 'I'.
    s_ersda-option = 'GE'.
    s_ersda-low    = p_startdate.
    APPEND s_ersda.
    s_laeda-sign   = 'I'.
    s_laeda-option = 'GE'.
    s_laeda-low    = p_startdate.
    APPEND s_laeda.
  ENDIF.

  " 第三种情况：开始日期为空，结束日期不为空
  IF p_startdate IS INITIAL AND p_enddate IS NOT INITIAL.
    s_ersda-sign   = 'I'.
    s_ersda-option = 'LE'.
    s_ersda-low    = p_enddate.
    APPEND s_ersda.
    s_laeda-sign   = 'I'.
    s_laeda-option = 'LE'.
    s_laeda-low    = p_enddate.
    APPEND s_laeda.
  ENDIF.

  " 第四种情况：开始日期和结束日期都不为空
  IF p_startdate IS NOT INITIAL AND p_enddate IS NOT INITIAL.
    IF p_enddate >= p_startdate.
      s_ersda-sign   = 'I'.
      s_ersda-option = 'BT'.
      s_ersda-low    = p_startdate.
      s_ersda-high   = p_enddate.
      APPEND s_ersda.
      s_laeda-sign   = 'I'.
      s_laeda-option = 'BT'.
      s_laeda-low    = p_startdate.
      s_laeda-high   = p_enddate.
      APPEND s_laeda.
    ELSE.
      EXIT.
    ENDIF.
  ENDIF.