Using Relative Dates (IN Operator) in Criteria of Servicing Director Reports and Letters

Using Relative Dates (IN Operator) in Criteria of Servicing Director Reports and Letters

In Servicing Director, you can use relative dates when you schedule a recurring report or letter that uses the report writer and includes date criteria on the New or Edit Filter screens. Relative dates save time because you do not have to adjust the absolute date of a daily, weekly, monthly, or annual report each time you want to run that document. Relative dates in report writer are relative to the system date on the computer where the report or letter is run; this date may differ from your transaction posting date.


 

Today is June 1, 2013 and you want a report that shows the 2013 history for a loan. On the New Filter screen, you can create a filter that uses a relative date for the report:

Field   : TransactionDate
Operators : IN 
Value  : YearToDate
 
If you did not use a relative date, your filter would require two statements and would only be useful on June 1. On June 2, you would have to edit the transaction date value in the second statement.

TransactionDate > 12/31/12
TransactionDate <= 06/01/13

 

Note:

You cannot use relative dates for imports, exports, or documents that use the Mail Merge feature in Microsoft Word.

 

To use a relative date in Event Manager: 

  1. Open Event Manager. The Event Manager screen appears.
  2. In the Available Events list, expand a category, and then expand a group that contains a report or letter that uses the report writer.
  3. Select the report or letter, and then drag it to the Scheduled Instances list.
  4. Select the report or letter from the Scheduled Instances list, and then click Criteria. The Instance Criteria screen appears.
  5. Click New. The New Filter screen appears.
  6. Select the filter criteria for a date from the Fields drop-down list.
  7. Select In from the Operators drop-down list.
  8. Select a relative date from the Value drop-down list, and then click OK. The Instance Criteria screen reappears.
  9. Click Send. The Print screen appears.
  10. Select the name of the printer you want to send your statements to, and then click OK. A confirmation message appears.
  11. Click OK. The Instance Criteria screen reappears.
     

 

 

ArticleNumber:

000047282

    • Related Articles

    • Changing Your Servicing Director Company Name Or Details on Letters and Reports

      If your company has a name change or if there are some other changes necessary, such as changes to your address or telephone number, then change the Servicing Director information in Table Setup, and the new, correct information will appear on all ...

    • Adding Servicing Director Report Filter Criteria

      Servicing Director reports are delivered with many choices for report filter criteria, but not all the possible fields available for every report are setup as filter criteria. You can add any fields which are available but not already setup as filter ...

    • Setting Up Module Reports in Servicing Director

      The system administrator for Servicing Director can designate from which modules a particular report can be run. (This does not apply to end-of-day reports. Those reports should be scheduled through the Event Manager.) The system administrator can ...

    • Definitions of the Servicing Director Current, Prior and Last Transaction Dates.

      The three Servicing Director Transaction Dates: There are three Servicing Director transaction dates viewed by opening the System Administration application>Table Setup>Company>Transactions tab>Transaction Posting Dates section. The current ...

    • Reinstalling Crystal Reports

      Fusion Servicing Director includes a specific version and edition of the SAP product called Crystal Reports for Visual Studio 2010 Run Time version 13.0.15.1840 32-bit. The Crystal Reports application is automatically installed the first time the ...