Is there a way to use dates to find records dynamically in an automation.
I have a line items table for my orders. That table links to an Item in another table
Then we have a third table that contains pricing records for each item with a start and end date for that pricing validity.
I am trying to source the price for the line item by looking at the order date and then pulling the price from the pricing record in effect when that order is set to load.
