Take a look at DateAdd() I'm pretty sure you could add -1 day to Now(). If not you could use DatePart() and Now() to yank the current day/month/year....then subtract 1 day from the day and use CreateDate() to put it all back together!!
I hate dates ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Parker, Kevin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 17, 2003 3:54 PM Subject: Date maths > Is this how you work out yesterday's date? I seem to vaguely recall that > date maths was a bit different to normal maths. > > CreateDate(now() - 1) > > > TIA!!!! > > ********** > Kevin Parker > Web Services Manager > WorkCover Corporation > > e: [EMAIL PROTECTED] > w: www.workcover.com > > p:+ 61 8 8233 2548 > f: +61 8 8233 2282 > m: 0418 806 166 > ********** > > > > ************************************************************************ > This e-mail is intended for the use of the addressee only. It may > contain information that is protected by legislated confidentiality > and/or is legally privileged. If you are not the intended recipient you > are prohibited from disseminating, distributing or copying this e-mail. > > Any opinion expressed in this e-mail may not necessarily be that of the > WorkCover Corporation of South Australia. Although precautions have > been taken, the sender cannot warrant that this e-mail or any files > transmitted with it are free of viruses or any other defect. > > If you have received this e-mail in error, please notify the sender > immediately by return e-mail and destroy the original e-mail and any > copies. > ************************************************************************ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
