Date Problem, Won't Show Properly

How to do if I have 2 cutoff date for online registration. There are 2 set of fee when user regiser. Early registration and after registration example

below code won't work

today = date
                    if today < 8/10/2007 then
                    sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/10/2007#
order by id asc"
                    else
                    sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/11/2007#
order by id asc"
                    end if