WHERE Year(databaserecord.date) = #FORM.year#
btw, name a column as "date" is not a good practice.
>I've got a "smalldatetime" field in a SQL database.
>
>In a query, I need to be able to pull all records where the year of this
>field equals the year value entered in a form..
>
>Don't have too much trouble comparing dates outside of queries, but
>inside I always get something wrong...
>
>I'd love to be able to do womething like:
>
>WHERE #DateCompare(form.myDATE, databaserecord.date, yyyy)# = -1
>
>
>...but that doesn't work....
>
>Pointers please?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
