Even though I had seen that you had a solution I thought that there could be a way with the ADDDAY and DNW functions but I failed!
It sounds to me like a good enhancement request, however, ADDBusinessDays along the lines of ADDDAY with the same negative usage to go backwards. Just a thought, Regards, Alastair. From: Dan Goldberg Sent: Monday, July 08, 2013 3:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: calculating dates 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 From: Dan Goldberg Sent: Monday, July 08, 2013 7:20 AM To: RBASE-L Mailing List Subject: [RBASE-L] - calculating dates I need to display a date in a view/report that is three business days previous to another date. I can easily do (columndate – 3) but I need to omit saturday and sunday from the date calculation. 7/8/2013/Monday – 3 days would be 7/3/2013 7/9/2013/Tuesday – 3 days would be 7/4/2013 7/10/2013/Wednesday – 3 days would be 7/5/2013 7/11/2013/Thursday – 3 days would be 7/8/2013 I can write a routine to calculate at each row, one by one, to calculate them but I was hoping that there is an easy way to accomplish this. If anyone has any ideas please let me know. TIA Dan Goldberg
