>
>lol forgive my lazy internet lingo i meant to work. you're using the year 2000 i really didnt wanna hard code a year

Alternative solution would be

year(date) = thisform.Spinner1.value

this solution is worse if you have an index on date field. Otherwise it doesn't matter and shorter to use.