Bruce Thanks for your reply and suggestion. I was surprised that the function TDWK handles Sunday as the "7th" day of the week while the function IWOY handles Sunday as the "1st" day of the week. Of well, I'll get around it. Angelo
From: [email protected] To: [email protected] Subject: [RBASE-L] - RE: Missing setting or function. Date: Thu, 14 Nov 2013 14:13:10 -0800 Angelo: Some time back Dan Goldberg provided this thread. Perhaps there are some clues there. Bruce ChitieaSafeSectors, Inc.eCondoMetrics 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 AMTo: RBASE-L Mailing List Subject: [RBASE-L] - calculating datesI 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/20137/9/2013/Tuesday – 3 days would be 7/4/20137/10/2013/Wednesday – 3 days would be 7/5/20137/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 GoldbergFrom: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, November 13, 2013 7:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Missing setting or function. I need to print some detail reports, by week. Function IWOY assigns a week number with Sunday being considered the first day of the week, I need Sunday to be the last day of the week. I realize that I can write code around this problem but thought I might be missing something. Angelo
