I'm trying to scan a date field for records that are in the month of may 1999 is there a function or comgination of functions to do this?

Any Help will be greatly appreciated!