Thank you Koen and Craig for your reply.

I will keep in mind Craig's advice, but based on the fact I have a deadline, I will go with passing the variable to the query on the OLE source.

I have already tried that out, the first time is a pain in the behind since it has to load the whole table, but then only the records which date is newer to the max date.

Thanks both of you for your help.

Regards.