Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
CAN YOU HELP ME PLEASE!!
I need to convert the sales to the corresponding exchange rate.
I have the table of exchange rate and the table of sales.
my question is if the date and the exchange rate are not registered, that assigned the last registration or the previous registration.
Hi Denise
This article could maybee be useful
And after you have a table with the intervals you can either use a while loop to make records for all the missing dates or you can use the intervalmatch function
Regards
Peter
Hi Denise
If you want register the prevous or last exchange date when the date are not registered, my suggestion is complete the exchange table, i can send an script example to achieve the request
Hi Denise
This article could maybee be useful
And after you have a table with the intervals you can either use a while loop to make records for all the missing dates or you can use the intervalmatch function
Regards
Peter