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
