Date filter is a combination of several date filters within one include file. The following formatting should be used when you define a parameter:
yyyy-mm-dd or yyyy-mm-dd hh24-mi-ss, for example 2013-01-01 or 2013-01-01 15-00-00
| Info |
|---|
|
| These filters have sense only if the EagleML object you want to extract contains the corresponding database field. |
| Expand |
|---|
| title | Click to expand task parameters that stand for date filter: |
|---|
|
| Filter Name | Available Parameters | DB Field | | Update Date | updatedate
todate
fromdate | UPDATE_DATE | | Effective Date | effectivedate
fromeffectivedate
toeffectivedate | EFFECTIVE_DATE | | Release Date | releasedate
fromreleasedate
toreleasedate | RELEASE_DATE | | Accounting Date | accountingdate
fromaccountingdate
toaccountingdate | ACCOUNTING_DATE | | Month End (Accounting) Date | monthendaccountingdate
frommonthendaccountingdate
tomonthendaccountingdate | MONTH_END_ACCOUNTING_DATE
MONTH_END_DATE
GLDP_ACCOUNTING_DATE | | Post Date | postdate
frompostdate
topostdate | POST_DATE | | Valuation Date | valuationdate
fromvaluationdate
tovaluationdate | VALUATION_DATE | | Ledger Effective Date | ledgereffdate
fromledgereffdate
toledgereffdate | LEDGER_EFFECTIVE_DATE | | Trade Date | tradedate
fromtradedate
totradedate | TRADE_DATE | | Settlement Date | settlementdate
fromsettlementdate
tosettlementdate | SETTLEMENT_DATE | | Start Date | startdate fromstartdate tostartdate | START_DT | | End Date | enddate fromenddate toenddate | END_DT |
|
| Anchor |
|---|
| Date_Filters_Reference_Table |
|---|
| Date_Filters_Reference_Table |
|---|
|
Date Filters Reference Table
...