Business rule Help

[former_member123502]

I have the following requirement in employee central.

I have a portlet containing 3 fields - Start date (Date type), End date (Date type), Date Difference (String type).

The requirement is to write a business rule to set the Date Difference field in the format (X Years, Y months, Z Days) based on Start date field value and End date field value.

Thanks in advance for your help.

[nlgro023]

Well in terms of structure it would be something like this (and each number would be a format as shown in the initial clause).

The problem is that it will be very challenging to come up with something to get a correct reflection of the months and days (that would be a lot of variables most likely with deep calculations), where you'd be working with the outcome of Get Number Of Calendar Days()