Forum Discussion
MarkShnier__You
Qrew Legend
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
------------------------------
Monday -> Wednesday
Tuesday -> Wednesday
Wednesday -> Wednesday
Thursday, Friday, Saturday, Sunday -> the next Wednesday
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
CourtneyLaw
3 years agoQrew Member
Correct!
------------------------------
Courtney Law
------------------------------
------------------------------
Courtney Law
------------------------------
- MarkShnier__You3 years agoQrew LegendOK, 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
------------------------------- CourtneyLaw3 years agoQrew MemberThis formula seems to be working. Thank you very much!
------------------------------
Courtney Law
------------------------------