Here are the access function
Date(x)
Dateadd("<Access datepart>",x,y)
Datediff("<Access datepart>",x,y)
Datepart("<Access datepart>", x)
Day(x)
Hour(x)
Minute(x)
Month(x)
Now(x)
Second(x)
Weekday(x)
Year(x)
You can create a customer column in a seach action
example
Month(<field_name_here>)
--- Robert Garcia <[EMAIL PROTECTED]> wrote:
>Or if you aren't in special ed like me, you might do:
>
>select uid,thedate,name from theTable where month(thedate) = 8
>
>Sorry, I ain't to bright sometimes.
>
>Robert.
>
>
>On Friday, August 15, 2003, at 03:05 PM, Robert Garcia wrote:
>
>> If access suports this, you could do a custom column, or direct dbms
>> action like this, assuming a table of three columns uid,thedate,name:
>>
>> select uid,thedate,name where month(thedate) = 8
>>
>> That will give you all of august of every year.
>>
>> Robert.
>>
>> On Friday, August 15, 2003, at 02:10 PM, noel estabrook wrote:
>>
>>> Hard to believe I've never run into this before, but...
>>>
>>> I want to do a query on a Data/Time field (Access). I want to get
>>> records where the date is of a certain month and/or a certain year.
>>> But when I go to build the search action, all of the Begins With,
>>> Contains and Ends with functions are all grayed out. Short of doing
>>> a straight SQL query, is there any way to accomplish such a thing?
>>>
>>> TIA.
>>>
>>>
>>> __________________________________
>>> Do you Yahoo!?
>>> Yahoo! SiteBuilder - Free, easy-to-use web site design software
>>> http://sitebuilder.yahoo.com
>>> ______________________________________________________________________
>>> __
>>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
>>>
>>>
>>
>> --
>>
>> Robert Garcia
>> President - BigHead Technology
>> CTO - eventpix.com
>> 2781 N Carlmont Pl
>> Simi Valley, Ca 93065
>> ph: 805.522.8577 - cell: 805.501.1390
>> [EMAIL PROTECTED] - [EMAIL PROTECTED]
>> http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
>>
>> _______________________________________________________________________
>> _
>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
>>
>>
>
>--
>
>Robert Garcia
>President - BigHead Technology
>CTO - eventpix.com
>2781 N Carlmont Pl
>Simi Valley, Ca 93065
>ph: 805.522.8577 - cell: 805.501.1390
>[EMAIL PROTECTED] - [EMAIL PROTECTED]
>http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
>
>________________________________________________________________________
>TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
_____________________________________________________________
The best email provider on today's market, sign-up now for as low as $20.00 AUD per
year! http://www.aussiemail.com.au
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
