Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
titleNote
​These filters have sense only if the EagleML object you want to extract contains the corresponding database field. 


...

Filter NameAvailable ParametersDB Field
Update Dateupdatedate
todate
fromdate
UPDATE_DATE 
Effective Dateeffectivedate
fromeffectivedate
toeffectivedate
EFFECTIVE_DATE 
Release Datereleasedate
fromreleasedate
toreleasedate
RELEASE_DATE
Accounting Dateaccountingdate
fromaccountingdate
toaccountingdate
ACCOUNTING_DATE
Month End (Accounting) Datemonthendaccountingdate
frommonthendaccountingdate
tomonthendaccountingdate
MONTH_END_ACCOUNTING_DATE
MONTH_END_DATE
GLDP_ACCOUNTING_DATE
Post Datepostdate
frompostdate
topostdate
POST_DATE
Valuation Datevaluationdate
fromvaluationdate
tovaluationdate
VALUATION_DATE
Ledger Effective Dateledgereffdate
fromledgereffdate
toledgereffdate
LEDGER_EFFECTIVE_DATE
Trade Datetradedate
fromtradedate
totradedate
TRADE_DATE
Settlement Datesettlementdate
fromsettlementdate
tosettlementdate
SETTLEMENT_DATE
Start Datestartdate
fromstartdate
tostartdate
START_DT
End Dateenddate
fromenddate
toenddate
END_DT
Sweep Datesweepdate
fromsweepdate
tosweepdate
SWEEP
_DATE

...

titleClick to expand task parameters that stand for date filter:

...

_DATE

...

startdate
fromstartdate
tostartdate

...

enddate
fromenddate
toenddate

...


Anchor
Date_Filters_Reference_Table
Date_Filters_Reference_Table
Date Filters Reference Table

...