How to separate Date in query?

[yosiro]

I want to seperate date on query field.
Eg. in the field date show 12/3/2012
so i want to seperate just year in a new field

in excel we known MID LEFT RIGHT function

[Seth Schrock]

If the date 12/3/2012 is in a field called DateField, then you would have the following in your query:

Year(DateField) AS YearField

You can do the same thing with Month() and Day().

Note: Don't name a field Year, Month, or Day, or Date even as an alias (the part after the AS) as these are reserved names and can cause problems when trying to reference them. Hence, my naming it DateField and YearField. You can can change the alias to be more descriptive for its use.