Hi again,

I m having a date of a field xxx, in this type 31-Okt-2005, and I would like to take only the year!
I tried 1: DatePart ("yyyy",[xxx]) but it doesn't work I think it doesn't want the comma(,).
What should I DO?

tHANKS

You need to do this:

Year:(DatePart("yyyy", [DateField]))

A new query field will require these extra parens.

Also, you need to make sure that the system settings will see this as a date. If not, then you need to do this:

Year:(Right[DateField], 4)

Does this help?





mmcdonal

You can also use the YEAR() function. For example, Year(Date()) will currently give you 2006.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division