But then it is wrong for the cases where ttod(mycursor.createtime)=thisform.txtdate() except midnight

Intention was to compare on a daily base (date vs. date) not on time as Time vs. Date. (As suggested by the TTOD)

Agnes
>Hi Agnes,
>
>But Chaim use ">" not "="
>
>MartinaJ
>
>>Hi MArtina,
>>
>>are your sure?
>>
>>if mycursor.createtime is Time (as TTOD suggests) it should return mostly false since the date value will be changed to {^YYYY.MMM.DD 00:00:00}
>>
>>DATE()=DATETIME() is true it at midnight only
>>