I have a dataset like this:
I understand that we have the “from_dataset” function which allows us to pick columns from a dataset provided that a particular value match. However, what if I want to compare the values instead of finding a match value? For example:
from_dataset(“Price History”, “Price”, Start_Date: < field(‘Date’) and End_Date: > field(‘Date’))
So instead of finding matching values with a column, I need to find the rows where our ‘Date’ column will be between the start and end date and choose the price.