Date: Excluding Weekends in a spcified calc

[fishbone]

As I build my database, i constantly run into problems that my brains can't figure out all alone.

Anyway, I have a "last call" and "next call" field with buttons. The "last call" field inserts current date (fine..no problem. super easy to do).

My "next call" field/button brings up custom dialog for "one day," "3 months" or "exact date."

Regardless of that,

I need to specify a calculation that if the next call equals a Saturday or Sunday, automatically inserts "Monday" into the next call field.

Do you follow me? I hope so.

More importantly, do you have any suggestions?

[mr_vodka]

fishbone,

Try somthing like this.

Let ( [ dw = DayOfWeek ( Date); f =  Case (dw = 1; Date + 1; dw = 7;  Date + 2; Date)] ; f )

If you want to consider holiday etc. You will have to modify this calc of course.

[fishbone]

Let me try this in just a bit. I will try it out. It should work. I'll let you know.

Thanks.

[mr_vodka]

I guess to take your fields, and tweak the calculation that you will use in your calculated results field, try this one instead.

Let ( [ dw = DayOfWeek ( Date); 

               d = next call;

               f =  Case (dw = 1; d + 1; dw = 7;  d + 2; d)

            ]; 

            f 

          )

[-Queue-]

See if the attachment helps you also.

NextCall.zip