Yep, I'm copying this into my bag of tricks! Karen
-----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Jul 8, 2013 10:14 am Subject: [RBASE-L] - Re: calculating dates Neat trick, Dan. Thanks for letting us know. Albert On 08/07/2013 8:50 AM, Dan Goldberg wrote: > Nvm, I have figured a way. > In the report I used some functions and placed them into variables. I > would get the day of the week. If the day of the week is less than 4 > then subtract 5 instead of 3. > INTEGER : D : vdow = (idwk(onlinedate)) > INTEGER : D : vdaysub = (iflt(.vdow,4,5,3)) > DATE : D : vreqdate = (onlinedate - .vdaysub) > Dan Goldberg >
