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
