Hi All,

I'm not sure if this is the correct place to post this so if it is
not
then I would appreciate it if I could be pointed to the correct place.

My question is: How do I select records in an IB table where the
month and year of a date field = 8 and 2000 respectivaly.

I have tried MONTH(field), DATEPART("m", field), EXTRACT MONTH FROM
field and none of these functions work in IB.

TIA,

Gerald S. Brown