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? ...

CourtneyLaw

Qrew Member

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
------------------------------