Operation Details |
Description: | Method to return a list of exclusion dates in ascending order within the date range entered. |
Sterotype: | nsmulti |
SQL |
SELECT financialCalendarID, exclusionDate, deliveryMethodType, prePaymentInd INTO :financialCalendarID, :exclusionDate, :deliveryMethodType, :prePaymentInd FROM FinancialCalendar WHERE exclusionDate >= :dateFrom AND exclusionDate <= :dateTo ORDER BY exclusionDate ASC |