someone know how to convert from sql to TERA:
whereconvert(int,convert(varchar,getdate(),112)) not between a.FromDate and convert(int,convert(varchar,convert (datetime , CONVERT (datetime,LEFT(a.ToDate,8)) , 101)+ 1 ,112))
**ToDate <= convert(int,convert(varchar,getdate()-1,112))
**FromDate = convert(int,convert(varchar,getdate(),112))
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.