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
Thanks for the help. The Assignment date can be any given day of the week
------------------------------
Ermias Bean
------------------------------
------------------------------
Ermias Bean
------------------------------
Today just happens to be Wednesday.
------------------------------
Ermias Bean
------------------------------
------------------------------
Ermias Bean
------------------------------
- Understood. The question is, if the Assignment Date is on Thursday the 19th, would the End Date still be April 8th since it was assigned in the same week, or would it get pushed out to the 15th of April since it was assigned after the nearest Wednesday?
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------- the end date will still be April 8th
------------------------------
Ermias Bean
------------------------------
- Ermias,
Since today is Wednesday the 18th, does that count as one Wednesday on the way to three or is today always zero on the way to three?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------- No it doesn't count. it is 3 Wednesdays after today - with April 8th being the third Wednesday.
------------------------------
Ermias Bean
------------------------------- 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
------------------------------
