>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)
It's true...
But main idea in my example was using parameter in macro.
And your notice is important :-)
MartinaJ
>
>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
>>>