Formula date field third Wednesday
Looking for a formula date field calculating the third Wednesday after a date field "Assignment Date" for example; If the "Assignment Date" is today (18th of March) then this "Date field (Lets call...
Forum Discussion
Ermias,
Try this as a Formula Date Field
var Number DayNumber = DayOfWeek([Assignment Date]);
var date TodaySunTue = NextDayOfWeek([Assignment Date], 3)+ Days(14);
var date TodayWedPlus = [Assignment Date]-Days($DayNumber-3) + Days(21);
If ( $DayNumber<3, $TodaySunTue, $TodayWedPlus )
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Try this as a Formula Date Field
var Number DayNumber = DayOfWeek([Assignment Date]);
var date TodaySunTue = NextDayOfWeek([Assignment Date], 3)+ Days(14);
var date TodayWedPlus = [Assignment Date]-Days($DayNumber-3) + Days(21);
If ( $DayNumber<3, $TodaySunTue, $TodayWedPlus )
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Ermias,
This formula should work as well. You are always just going three weeks after the previous Wednesday, unless it is a Wednesday, then you are just going three week from that day.
if(DayofWeek([Assignment Date] !=3,
PrevDayofWeek([Assignment Date], 3) + Days(21),
[Assignment Date] + Days(21))
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
This formula should work as well. You are always just going three weeks after the previous Wednesday, unless it is a Wednesday, then you are just going three week from that day.
if(DayofWeek([Assignment Date] !=3,
PrevDayofWeek([Assignment Date], 3) + Days(21),
[Assignment Date] + Days(21))
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
