Need help with Excel Microsoft Query

Giganews Newsgroups
Subject: Need help with Excel Microsoft Query
Posted by:  erick-flores (erickjflor…@gmail.com)
Date: Wed, 29 Aug 2007

Hello all

I want to add a field to my query based on another field. The "another
field" is a date field (field_date).

What I want to do is: IF(field_date >=01/01/00 and <=12/31/00, "2000",
0)

I want to get the year by itself based on the field_date, perhaps
there are another ways of doing this?

But obviously i am missing something or doing something wrong, because
when I tried to run the query i get the Sysntax error.

Thanks in advance

Replies