Skip to main content
Question

Creating task with a specific due date

  • May 4, 2022
  • 0 replies
  • 59 views
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 or March 1 based on the start date (so if the Person is hired and task is created in September, October, November, December, January, or February the task will be due March 1.  If it is a March, April, May, June, July, or August hire will have a due date of September 1).  How would I write my formula to say if this is the start date, then this is the due date?  Thank you!

------------------------------
Xenia Watterson
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+11
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
------------------------------
Terms & ConditionsAccessibility statement