Use IYR4 in that formula to avoid any possibility of error. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, February 28, 2011 2:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Calculate date
Bill, If I understand you correctly try SET VAR vStartDate = (RDATE (12,31,(IYR(ADDYR(.#DATE,-1))))) Jan -----Original Message----- From: "Bill Owens" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 28 Feb 2011 15:18:14 -0500 Subject: [RBASE-L] - Calculate date I would like to set a variable based on today's date (02/28/2011 to show December 31, 2010 (Last year December date)? I always want to show Last December 31 date Thanks Bill
