Currency table to pick earlier date when not available

Hi experts :)

I'm making a report that will check the posting date and pick the relational ex. and exchange rate for a given currency, from the currency exchange rate table. The problem is that sometimes we use a different source for exchange rates where one rate is used for the whole month. Navision picks the earlier rate available in the table which is correct. However, if I use an NL function to pick a specific currency exchange rate for a specific date, it will not because it will validate the date and if it does not find this date in the table, no rate will be returned.

Is there a Jet function/formula or an Excel formula that will pick the earlier available date from the table?

Thanks in advance! 8-)


Please sign in to leave a comment.