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]] 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
