Can Someone please help me Calculate Year and months

Question

The input should come from the date field and the output should include the year and the months in decimal. for example: Input 03/05/2016  the output: 6,5.

.value: if(
                    a!isNullOrEmpty(ri!dealerBusiness.dateOrganized),
                    null,
                    /*calculate the age of the person*/
                    int(right(today(), 4)) - (
                      right(ri!dealerBusiness.dateOrganized, 4)
                    )
                  ),
This what I have so far.

mikes0011 · Answer

I don't understand what you mean "in decimal"? Could you give a little more detail as to what exaclty your data inputs are, what the corresponding output should be, and why?

If you just want a read-out of the elapsed years, elapsed months: check out the "elapsedmonths" function in the Date and Time Utilities plug-in.

Sign up

Login with SSO

Login to the community

Login with SSO