=DATESTRING(ADGET("gldates.END","C12"),"%Y")
What is wrong with this formula for an ending balance on the selected date as of e.g. October 31, 2006. It looks like it's giving me the previous year balance even if the column heading shows 2006.