I haven't the time today, but I'm thinking ADDDAY and the creation of a "virtual Seventh Day" is the path to solution.
Bruce From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, November 14, 2013 4:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Missing setting or function. 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] <mailto:[email protected]> To: [email protected] <mailto:[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 Chitiea SafeSectors, 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 <mailto:[email protected]> Sent: Monday, July 08, 2013 7:20 AM To: RBASE-L Mailing List <mailto:[email protected]> 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 From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected] <mailto:[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
