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]
