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
>>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]