Grrrr! You're right!
I didn't mean to have month(now()) in there.. You know I read over the code again and again and I didn't notice that Month was there! And when it works I must have written the code over and left out the Month...without even realising and..and.. And I think tis time to go home. *nods firmly* -Gel ^_^ -----Original Message----- From: charlie griefer [mailto:[EMAIL PROTECTED]] Angel Stewart writes: > Hey all... > > #CreateDate(Year(Now()),Month(Now()),DaysInMonth(Month(NOW())) > > That statement gives this error message: > > An error occurred while evaluating the expression: > > > #CreateDate(Year(Now()),Month(Now()),DaysInMonth(Month(NOW())))# > > Error near line 87, column 88. It's your daysInMonth() function...daysInMonth() takes a full date as the argument. You're passing it an integer to represent month. This can't work, as CF needs a full date to determine days in month (february will either be 28 or 29 depending on the year). So... #CreateDate(Year(Now()),Month(Now()),DaysInMonth(NOW()))# should do it for you. hth, Charlie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
