Greetings, I need to add 3 days to a date, but the date cannot be a Sunday. What function can I run that would give me that result?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Gerry

Gerry

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
WeekDayAdd([my date field],3)
Photo of Gerry

Gerry

  • 0 Points
That doesn't allow the date to be a Saturday...
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Ok, I assumed that you meant to avoid weekend. Mea Culpa.

Try this one

var date DateTest = [My Date Field] + Days(3)
If(DayOfWeek($DateTest)=0, $DateTest + Days(1), $DateTest)
Photo of Gerry

Gerry

  • 0 Points
This worked like a charm!  Thank you sir!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Great. Thx for letting me know.
Photo of Angela

Angela

  • 0 Points
I found this and used it for one of the applications I'm working on. This is amazing... Thank you!!