Well, I think I wanna do something that just can't be done with VFP. This is what I got and it works:


vvGrid.COLUMNS[14].CONTROLSOURCE= "AllTrim(Str(Month(lv_compete.competedate))) + ' - ' + Right((AllTrim(Str(Year(lv_compete.competedate)))),2)"



Now this is what I REALLY REALLY wanna be able to do, but VFP doesn't seem to like this. I'm assuming it's because of the 'IIF' in there...so is there some kinda workaround for this?


vvgrid.COLUMNS[14].CONTROLSOURCE= "IIF(Month(lv_compete.competedate=1.and.Day(lv_compete.competedate)=1,AllTrim(Str(Year(lv_compete.competedate))),AllTrim(Str(Month(lv_compete.competedate))) + ' - ' + Right((AllTrim(Str(Year(lv_compete.competedate)))),2))"