Post Author: Dorothy
CA Forum: Formula
I am using CR XI and am using a SQL Server database. I have a date field Class1Date that I'd like to break down
All dates would be Monday thru Fri. Currently the dates appear like so - 1/14/2008 12:00:00AM. What I'd like is if the day of the date falls on a Mon or Tues I'd like to have a mail by date equal to the Monday of that week. If the day falls on a Wed, Thur or Fri, I'd like to have a mail by date equal to Wednesday of that week.
Any help is appreciated.