Skip to Content
0
Former Member
Jan 02, 2008 at 08:06 PM

Find Day of Month

16 Views

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.