Discussions

 View Only

Date range with non-consecutive Dates

  • 1.  Date range with non-consecutive Dates

    Posted 07-12-2021 14:41
    We have a table we use for site visits our technicians make to a customer's site.  Currently we allow a single visit for all consecutive day visits (so imagine a 3 day visit on Monday - Wednesday), but if there is a gap in visit days (such as the weekend or a scheduled pause for a quality control check) we require a second visit is made for the next set of days.  The reason for this is the formula to show the next scheduled date/time (so if the visit starts on Monday, once that day is done the formula will show Tuesday as the next scheduled day until the end of the days/nights indicated on the visit and then the field will go blank).  Is there a way to do the next scheduled date/time field with gaps for days that the visits are not scheduled as the gap days are not always on a Saturday/Sunday weekend?

    ------------------------------
    Xenia Watterson
    ------------------------------