|
One thing, after you download the date, or upload it, you can extract the month, day and year from your date field. You could even set up the left(Birthday,2) for month, and go to all that trouble. Dates are strored in long binary numbers. You can use date functions like month() day() or year() to extract just that piece of information. But to SEARCH by just the month, the best way I've found, is to explode the date into three separate fields for storing. I have an online history newspaper, as well as a calendar. You can search for any day of the year, or any year, etc. But it sure helps to explode the date. Love the example above using cfqueryparam. I'm spoiled. I like using the CFINSERT tag, which means all my form fields and values must be set prior (not during) inserting them into the database. ... just sayin'
|