Date Query Manipulation

[Bgreer5050]

I have a field "date" its format is set at General Date.How can pull the
date apart into seperate fields using a query? I would like a year, month
and day field.

Thanks

 

[Smartin]

I have a field "date" its format is set at General Date.How can pull the
date apart into seperate fields using a query? I would like a year, month
and day field.

Thanks

try
SELECT YEAR(NOW()), MONTH(NOW()), DAY(NOW())

PS don't use "Date" as a field name as it is a reserved word and can
confuse Access. Use "MyDate" or some such, or bracket the field like
YEAR([Date]).

HTH

 

[Bgreer5050]

Thanks.

Worked Great!

I have a field "date" its format is set at General Date.How can pull the
date apart into seperate fields using a query? I would like a year,
month and day field.

Thanks

try
SELECT YEAR(NOW()), MONTH(NOW()), DAY(NOW())

PS don't use "Date" as a field name as it is a reserved word and can
confuse Access. Use "MyDate" or some such, or bracket the field like
YEAR([Date]).

HTH