Thank you all the suggestions were fine. I need to explain myself more clearly though. I have a search by date form that lists the date like this: <cfloop index="i" from="1" to="#daysinmonth(today)#">
Today is: <cfset today = now()> I would like it to start with yesterday or better yet the first of the month to widen the search possibilities How can I set today to be the first day not the current day of the month? Robert O. -----Original Message----- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 14, 2006 11:32 AM To: CF-Talk Subject: Re: Yesterday in now() <cfset yesterday = dateAdd("d",-1,now()) /> On 3/14/06, Orlini, Robert <[EMAIL PROTECTED]> wrote: > I have today in a cfset as: <cfset today = now()> > > How can I do a cfset with yesterday? tried this: <cfset yesterday = now()-1> > but it did not work. > > Robert O. > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.385 / Virus Database: 268.2.2/280 - Release Date: 3/13/2006 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
