I’m having an issue with adding date filtering to my ordering app. I have a table of promotions with start and end dates that is used a reference from my orders table. A straight up Ref will pull in all the promotions as a drop-down selector as desired, but if I try to add a filter with dates I get an error.
I tried using FILTER, I tried SELECT, but in both cases I get “Cannot compare List with Date in (PromoName[StartDate] > TODAY())”
CustName | PromoName (Ref) | Qty
PromoName | StartDate | EndDate
Any help is appreciated