Using variables in dates

[sam1fletcher]

hi all
i would like to use a variable for the year in my date range.

this it what i thought it would be:

Dim ye as integer
ye = 2013

If Sdate < #4/1/ye# then
'do something
Else
'do Something
end if

Obviousely this is wrong. the first line of the if statement is higfhlighted

any ideas

Sam

 

[CJ_London]

try
if SDate<datevalue("04/01/" & ye) then

 

[pr2-eugin]

How about..

Dim ye as Integer
ye = 2013

If Sdate < [URL="http://www.techonthenet.com/access/functions/date/dateserial.php"]DateSerial([/URL]ye, 4, 1) Then
    [COLOR=SeaGreen]'do something[/COLOR]
Else
   [COLOR=SeaGreen] 'do Something[/COLOR]
End If

 

[sam1fletcher]

cheers eugin