Join by Date


I am trying to pull a currency factor onto a ledger entry from a bespoke table that sets:

  1. Currency Code
  2. Start Date
  3. End Date
  4. Account Type - Income or Balance
  5. Factor - Decimal

I am then bringing the Currency Code (LCY) and the Account Type into the G/L Entry Table

I can get the joins to work on  the currency and a condition on the Account Type which works OK.  the problem is when I try to add a Join in the data link by adding :

Start Date Greater or equal to Posting Date

This always returns a Null

Any thoughts




1 comment

Please sign in to leave a comment.