cquerystring = "ttod(mycursor.createtime)=19/06/2009"
try?ttod(mycursor.createtime)=19/06/2009 *or even ?date()=19/06/2009this will not work
cquerystring='' cquerystring='select * from mycursor where .t.'&&get all lines ldDated = thisform.txtdate() &&return is a date cdated=TRANSFORM(YEAR(ldDated)*10000+MONTH(ldDated)*100+DAY(ldDated),[{^9999-99-99}]) &&create proper literal cdone='ttod(mycursor.createtime)' cdt='>' cquerystring=cquerystring+' and '+cdone+cdt+cdated messagebox(cquerystring)&&show the query syntax for debug &cquerystringAgnes
cquerystring='' >cquerystring='select * from mycursor where .t.'&&get all lines >cdated=transform(thisform.txtdate())&&it's OK >cdone='ttod(mycursor.createtime)'&&&&&&&&&&Here the problem >cdt='>' >cquerystring=cquerystring+' and '+cdone+cdt+cdated >messagebox(cquerystring)&&show the query syntax for debug >&cquerystring