Thanks appnair for the reply, i wrote a simple java code with LAPI & did a search against the Modify date using the '>' operator which gave me the results, but i wonder how we can use SQL queries "Select DataID,Name,SubType form DTree where CreateDate (or ModifyDate) between and then the time...