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
