0

Join by Date

Malcolm Johnson

July 02, 2018 15:30

None

Follow

 Hi

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

Thanks

Malcolm

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis July 02, 2018 17:23

  Hello Malcolm -

  I see that you have posted this in the Jet Enterprise forum.  

  Are you querying the Enterprise Cubes?  A Data Warehouse?  or are you querying a Dynamics NAV database, directly?

  Could you provide samples of the queries or Jet function calls that you are using?