Looking for a +Weekdays functions like + Days(1) for duration because apparently WorkDays(1)/WeekDays(1) didn't work...

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Trying to schedule formulas for date.  Ran into problem with +Days(1) because it goes into weekend.  I saw something like WorkdaysAdd() but not sure if that would work if pulling from a field.  Because I currently have something like [Job Start Date] + Days(1).

Photo of Yang

Yang

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
Try this

WeekDayAdd([Job a Start Date],1)

It will return the Monday if the job start date was on Friday.
Photo of Yang

Yang

  • 0 Points
Thank you once again, you're a life saver!