Designer question

From: Anna Goff <agoff_at_smepa.com>
Date: 12 Jul 1999 21:13:42 GMT
Message-ID: <01beccab$1d7f2ba0$460101c0_at_agoff>



If you have a report that you only want to print for between two dates, how do you set this up in Designer? One step further, I need to do this for 2 date fields. Example of what I am trying to get Designer to do:

WHERE EMP.EMP_SEQ = DL.DL_EMP_SEQ
AND (DL.DL_COMM_EXPIRE >= :XBEGDATE
AND DL.DL_COMM_EXPIRE <= :XENDDATE)
AND (DL.DL_MED_EXPIRE >= :XBEGDATE
AND DL.DL_MED_EXPIRE <= :XENDDATE)

Any suggestions will be greatly appreciated!!! ...Anna... Received on Mon Jul 12 1999 - 23:13:42 CEST

Original text of this message