Of course you don't need to split it into date parts anyway...
Taz
> Doesn't MySQL have the DAY function?
>
> BTW: there's no need for the cfqueryparams, and you should be using a
WHERE
> clause
>
> <cfquery ...>
> SELECT TicketID
> FROM Tickets
> WHERE MONTH(dateCreated) >= #DatePart("m", f_date)#
> AND YEAR(dateCreated) >= #DatePart("yyyy", f_date)#
> AND DAY(dateCreated) >= #DatePart("d", f_date)#
> ORDER BY TicketID
> </cfquery>
>
> Taz
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
