Return tomorrows records if Monday thru Thursday

[pleashelp]

I am using CR XI. This is what I want to do. I have customers and their appointment dates. I am trying to get a list of appointments for the following day. But I only have appointments on Monday thru Friday. So, if tomorrow is Tuesday thru Friday, I want to return my appointments for the next day. If tomorrow is a Saturday or Sunday, then I want to return my appointments with Monday's date. Can anyone help me with this? Thanks!

 

[Turkbear]

Hi,
You can use the DayOfWeek function in a selection formula to do that, something like:

If DayOfWeek (currentdate) = 6 [COLOR=green]//Friday[/color]
 then 
  {Table.ApptDateField} = currentdate + 3 [COLOR=green]//Get Monday Appts[/color]
 else
  if  DayOfWeek (currentdate + 1) = 7 [COLOR=green]//Saturday[/color]
   Then
      {Table.ApptDateField} = currentdate + 2 [COLOR=green]//Get Monday Appts.[/color]
Else
{Table.ApptDateField} = currentdate + 1 [COLOR=green]//Get Next day's Appts.[/color]

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[pleashelp]

Thanks! I just put that into my slection formula, and it worked great!