Date Query Manipulation

's Computer Specifications

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

's Computer Specifications

Bgreer5050 wrote:
> 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
--
Smartin

's Computer Specifications

Thanks.

Worked Great!

"Smartin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Bgreer5050 wrote:
>> 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
> --
> Smartin

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date manipulation	=?Utf-8?B?TmV0d29ya1RyYWRl?=	Microsoft Access Queries	3	7th Oct 2007 07:39 PM
Date manipulation	Ruslan Shlain	Microsoft C# .NET	1	23rd Jan 2004 09:32 PM
DATE manipulation Query	Seahorse	Microsoft Excel Misc	4	17th Nov 2003 10:35 PM
date manipulation query	Ryan	Microsoft Access Queries	0	24th Sep 2003 05:01 AM
Date manipulation	steve	Microsoft Access Queries	1	2nd Aug 2003 04:34 PM