try the daysinmonth(date) function... endofthemonth = CreateDate(year(now()), month(now()), daysinmonth(now()))
Jeff Garza ----- Original Message ----- From: "Perez, Percy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 8:33 AM Subject: end of month function Hello all, Is there a End of month function in ColdFusion... I am trying to get the end of month for a date. excel has one, but I could not find one under the help files. eg: eomonth(1-15-2002) would return 1-31-2002 and of course, before I build one, I figure I ask first. Thanks Percy E Perez ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
