Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Weekends


Jeremy

Recommended Posts

Is there a general script I can place that will make sure none of the dates are on weekends and if they are move them to a Monday?

Link to comment
Share on other sites

If(DayName(DateField) = "Saturday"

DateField + 2,

 

If DayName(DateField) = "Sunday"

DateFiled + 1

))

 

Will move all weekend days to the following Monday.

 

Tom

Link to comment
Share on other sites

Sorry, the calc (dateType) should read:

 

Case(DayName(DateField) = "Saturday",

DateField + 2,

 

DayName(DateField) = "Sunday",

DateField + 1,

 

DateField)

 

This shows any weekday but converts Saturdays and Sundays to the following Monday.

 

Forget previous post.

 

Tom

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use