My problem here is i only want to compare the month and day, and igonore the year. the coding below can use to compare the date, but i wish to ignore the year comparing. Pls help me to edit.<BR><BR> &#039executed sql statement wihch will show the day and month<BR> which greater than 3/24, for examample.<BR><BR> date1=objRst.Fields(17)<BR> date2= currentdate<BR> if (datediff("d", date1, date2) =0 ) then<BR> <BR> &#039execute another sql statement to show the record which <BR> is &#062;3/24<BR><BR><BR>i need it urgently.Thanks, Louis<BR>