Pretty much like this ;-) (DatePart("m",[Table1]![mydate])) as <alias column name here>
ie. (DatePart("m",[Table1]![mydate])) as MonthOfMyDate Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Steve Campbell [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 1:49 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Search Action-only month Jami Thatıs what I was looking for. Doing it in a search criteria. Thanks Steve On 4/4/03 3:43 PM, "Wilcox, Jamileh" <[EMAIL PROTECTED]> wrote: > Actually, Access allows for datepart as well, but I don't know how to > set up a custom column to use it. > > (DatePart("m",[Table1]![mydate])) will pull the Month portion of mydate > from table 1 in an Access query. Now if anyone can explain how to use > that in a search criteria, you're in business. :) > > > > >> -----Original Message----- >> From: Steve Campbell [mailto:[EMAIL PROTECTED] >> Sent: Friday, April 04, 2003 3:13 PM >> To: [EMAIL PROTECTED] >> Subject: Re: Witango-Talk: Search Action-only month >> >> >> I sure could >> >> But this is for a customer..small project..and I used >> Access.. I know boo boo!! >> >> Steve >> >> On 4/4/03 2:56 PM, "Wolf, Gene" <[EMAIL PROTECTED]> wrote: >> >>> Couldn't you use a custom column in the search and then >> use the SQL >>> (DATEPART(PARM1, (PARM2))) function to compare the >> returning number to >>> the month you're looking for? >>> >>> >>> >>> -----Original Message----- >>> From: Steve Campbell [mailto:[EMAIL PROTECTED] >>> Sent: Friday, April 04, 2003 3:46 PM >>> To: [EMAIL PROTECTED] >>> Subject: Re: Witango-Talk: Search Action-only month >>> >>> >>> I have a search action that is bringing back items in a >> database. The >>> items are only a I.D., NewsTitle, Date (in 00/00/0000 for), >> and news >>> story. >>> >>> I only want to bring back the wants that match the current >> month that >>> we are in. I think that I could bring back like March for >> example, but >>> for the current month that we are in is what is baffling me. >>> >>> Any ideas would be appreciated. >>> >>> Thanks >>> Steve >>> >>> >>> >> ______________________________________________________________________ >>> __ >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to >> [EMAIL PROTECTED] >>> with unsubscribe witango-talk in the message body >>> >> ______________________________________________________________ >> __________ >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to >> [EMAIL PROTECTED] >>> with unsubscribe witango-talk in the message body >> >> >> ______________________________________________________________ >> __________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to >> [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body >> > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body