In SQL server there is a month function, i.e. month(getdate()) or month(mydate).
Access may have the same function. If you are going to be ordering them,
remember to take the year into account if it spans the end of a year.
David
sebastian palmigiani wrote:
>
> I have a date and time field in the form of 8/14/00 in an Access database. I
> want to be able to select out the distinct months in all the fields. It
> seems that I can't do that.
>
> Do I have to redo the database and separate the month? Or do I have to
> process the query with some kind of CF code?
>
> Sebastian
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
