We have a requirement to put in place where the notice period duration for a country is 1 month if the employee tenure/duration in the company is more than 6 months, ie 6 months and 1 day also. If tenure is less than 6 months into the organization, then the notice period should be 1 week.
While using the predefined function "get the number of months between start and end dates", where my start date is hire date and end date is current date, then the function behaves like if the tenure in company is equal to 6 or <6 months then the notice period is picked up as defined ie. 1 week.
When the duration is more than 6 months, then the function will consider the 1 month notice period only if the month has passed. Ex: if tenure is 6 months and 5 days, then the function picks up the 1 week condition. If the tenure is 7 months (post 6 months), then it considers the current condition or 1 month condition.
now my problem is, even if the tenure is 6 months and 2 days, the 1 month condition should be picked up and not 1 week.
Request anyone to help me on this issue. Business people are surprised on listening to the way SF is calculating the number of months. We should have an option to input decimal value also in Business rule similar to number. Kindly help if anyone has been able to implement similar requirement.
Regards,
Nagavalli B n
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.