Forum Discussion

Qrew Member

3 years ago

Formula Help Needed - Round a date to a specific day of the week

I am looking for a way to round a date field to a specific day of the week. I.e., my date falls on a Monday or a Friday, but I want the date field to show the upcoming Wednesday date. Any solutions? ...

MarkShnier__You

Qrew Legend

3 years ago

Is this the mapping you want?
Monday -> Wednesday
Tuesday -> Wednesday
Wednesday -> Wednesday
Thursday, Friday, Saturday, Sunday -> the next Wednesday

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

CourtneyLaw
Qrew Member
3 years ago
Correct!

------------------------------
Courtney Law
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  OK, try this
  
  var number DaysToAdd = Case(DayOfWeek([My Date Field]),
  1,2,
  2,1,
  3,0,
  4,6,
  5,5,
  6,4,
  0,3);
  
  [My Date Field] + Days($DaysToAdd)
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - CourtneyLaw
    Qrew Member
    3 years ago
    This formula seems to be working. Thank you very much!
    
    ------------------------------
    Courtney Law
    ------------------------------