Date Function

[Zittnat]

for example . . there is a memberDate field in member table . . i want to query the member who became the member before this year . . by using function . . ! i mean I don't wanna do like " WHERE memberDate < #1/1/2012# " pls . . help me thz

[pbaldy]

You mean dynamically determine the beginning of the year with a function? Use DateSerial along with Year(Date()) for the year argument.

[Zittnat]

thanks . . .
It works.

[pbaldy]

Happy to help, and welcome to the site.