;)Hi Gan,You have not any mistake in the query, But problem may there if your format in oracle registry is different.check the registri. For urjent you can find by using like statement for date field. Thanks Pramod. Pramod Kumar Dhal.CMS Computers ltd.,Mumbai.