Creating task with a specific due date
We have certain tasks that get created when new employees are hired. Most have due dates that are calculated a few days after the start date, but we want to add tasks that will be due on September 1 ...
Forum Discussion
You could try Month() function to find the month number of joining date, then if month is 12(Dec),1(Jan),2(Feb) define variable for start date accordingly.
var number doj = month([Join Date]);
IF($doj = 12 or $doj = 1 or $doj=2 , [due]=X,
if(
and so on
Making sense?
​​​
------------------------------
Prashant Maheshwari
------------------------------
var number doj = month([Join Date]);
IF($doj = 12 or $doj = 1 or $doj=2 , [due]=X,
if(
and so on
Making sense?
​​​
------------------------------
Prashant Maheshwari
------------------------------
- Thank you for the response. I'm comfortable finding the specific month it is created, I don't know how to say, if it is this month then the due date is 09-01 for whatever year. I've only ever done it as add however many days to the start date to figure out what the due date will be.
------------------------------
Xenia Watterson
------------------------------- After you find your DOJ logic with month , you can decide year with Year() logic ,
For September, October, November, December)
if month(doj)>8 then year(DOJ)+1 --> Next Year
if month(doj)<=8 then year(DOJ)
------------------------------
Prashant Maheshwari
------------------------------- Okay, that helps a lot I just wasn't thinking that. Thank you so much!
------------------------------
Xenia Watterson
------------------------------
