If statment

i have added a parameter wich has a selection ( start date and process date)
if user select start date then
select statment 1
else
select statment 2
end if

ive tried to write this if statment inside Dataset but give me an error
this designer doesnt graphically support the IF SQL construct

What is the error that you are getting?

Please post the actual code that you are using.

VB Code:

if @procDate ="Start Date" 
             SELECT *
             FROM         TableName
             WHERE     (Field1 >= @ProcDate1) AND (Field1<= @ProcDate2) 
else
            SELECT *
            FROM         TableName
            WHERE     (Field2 >= @ProcDate1) AND (Field2 <= @ProcDate2)

error
This designer does not graphically support the IF SQL construct.

Note ProcDate is a parameter which has 2 options Start date and process Date