This for some reason is not working for me and I am having a mind block. What I want to get the id of a row that is the most recent that is less than vdateeff
I tried: Set var vid= id in pvpn where partnumber = .vpartnumber and max(effdate) < .dateeff It gives me an error "illegal select function" I am probably missing something stupid. Anybody have any idea on what I am doing wrong? TIA Dan Goldberg
