Good point! (stupid! stupid! stupid!) Try this.
DateAdd("d", -1, DateAdd("m", 1, CreateDate(Year(Now()), Month(Now()), 1)))
______________________________________________________
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX: 301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW: http://www.euservices.com
______________________________________________________
> -----Original Message-----
> From: Pascal Peters [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 8:26 AM
> To: CF-Talk
> Subject: RE: end of month function
>
>
> I wouldn't try that in december.
>
> -----Original Message-----
> From: Bill Grover [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 24 april 2002 14:17
> To: CF-Talk
> Subject: RE: end of month function
>
>
> I just had to do this on one of our sites. Here is the code I use:
>
> DateAdd("d", -1, CreateDate(Year(Now()), Month(Now()) + 1, 1))
>
> ______________________________________________________
>
> Bill Grover
> Supervisor MIS Phone: 301.424.3300 x3324
> EU Services, Inc. FAX: 301.424.3696
> 649 North Horners Lane E-Mail: [EMAIL PROTECTED]
> Rockville, MD 20850-1299 WWW: http://www.euservices.com
> ______________________________________________________
>
>
>
> > -----Original Message-----
> > From: Perez, Percy [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 23, 2002 11:33 AM
> > To: CF-Talk
> > 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
> >
> >
> >
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
