I have a field that has a Date Range, like from 04/16/2010 to 04/19/2010:04/16/2010;04/17/2010;04/18/2010;04/19/2010
How can I exclude Saturdays and Sundays, so I end up with only Workdays using either a formula or Lotus Script?
04/16/2010;04/19/2010
Subject: Found my solution
I have two DateTime fields, Fld_SchedStartDate and Fld_SchedEndDate
In the Value Formula of a third hidden field I used the following formula and now I have only workdays. Yeahhhh.
I use that field in my calendar and it works like a charm.
MyDateRange:=@Explode(@TextToTime(@Text(Fld_SchedStartDate) +“-”+@Text(Fld_SchedEndDate)));
@Transform(MyDateRange; "x";@If(@Weekday(@TextToTime(@Text(x))) = 7 | @Weekday(@TextToTime(@Text(x))) = 1; @Nothing;@TextToTime(@Text(x))))
Subject: Try @BusinessDays