I’m having problems with my duration formula in the column of my calendar view. I have a formula to exlude weekends and only calculate business does in the field on my form. However when I try to have the duration count appear on my calendar view it continues to show on Sat and Sun. Please help.
Subject: Calendar View formula for excluding weekends
Calendar views are tricky. Your display and your duration aren’t related.
Your display is based on your personal settings (user preferences-Internation-Calendar) besides the default calendar view format changer from day, week, month, etc.
Your duration simply indicates how long the calendar entry will span.
If I’m off-base with understanding your problem, try looking into @Weekday.
HTH,
Justin
Subject: RE: Calendar View formula for excluding weekends
OK. That makes sense. But I’m still stuck.Here’s a snapshot of my Calendar View:
REM {Column1 contains the list of start dates as defined in the appointment form};
StartTime := @Time(CalendarDateTime);
DateList := @Explode(@TextToTime(@Text(CalendarDateTime) + “-” + @Text(EndDateTime)));
@TextToTime(@Text(DateList) + " " + @Text(StartTime))
REM {Column2 contains the duration for each appointment form};
Duration
What should appear in the “Column2” so that it skips the weekends?