DaysInMonth issue

2011-03-01 Thread Jeff Epstein
I just had a failure of the DaysInMonth function. For a report running on February data, from 2010-02-(01 hardcoded), to being DaysInMonth, the date result was 2010-02-31!! I had to hard-code 2010-02-28 as to to make the report work. Anybody else having February problems today with

Re: DaysInMonth issue

2011-03-01 Thread Matt Quackenbush
I think we'll need to see more code before we can be of much help. But in the meantime, if you're running DaysInMonth() today, March 1st, I would totally expect it to return 31. ~| Order the Adobe Coldfusion Anthology now!

Re: DaysInMonth issue

2011-03-01 Thread Azadi Saryev
well, it's March 2nd already here in Hong Kong, but nonetheless: if you had it as daysinmonth(now()), then today being March 1st it would have correctly returned 31... what exactly did you pass as argument to your daysinmonth() ? Azadi On 02/03/2011 00:05 , Jeff Epstein wrote: I just had a

re: DaysInMonth issue

2011-03-01 Thread Jason Fisher
-talk cf-talk@houseoffusion.com Subject: DaysInMonth issue I just had a failure of the DaysInMonth function. For a report running on February data, from 2010-02-(01 hardcoded), to being DaysInMonth, the date result was 2010-02-31!! I had to hard-code 2010-02-28 as to to make the report work

RE: DaysInMonth issue

2011-03-01 Thread Robert Harrison
Have you tried doing IsDate against your value to see if the value you are trying to feed to it is a date and not just a string that seems to look like a date? Try validating with IsDate and if it return false try rebuilding as a real date with CreateDate. Robert B. Harrison Director of

Re: DaysInMonth issue

2011-03-01 Thread Dan G. Switzer, II
I suspect the actual issue is that the script is running after midnight in whatever timezone his servers in. So, instead of getting 28 for February, he's getting 31 for March. -Dan On Tue, Mar 1, 2011 at 11:27 AM, Robert Harrison rob...@austin-williams.com wrote: Have you tried doing