how to create a calculated field which calculate the difference between years

(0) Share

Report

Posted on by alexyou

385

I'm trying to create a calculated field which can calculate the number of years the trick here is that my user enter only the year (yyyy) and not full date (dd/mm/yyyy) this is the first field year the second year is the current year so basically I need to create a calculated field which will calculate the number of years between the user year and the current year.

I was trying to use function DIFFINYEARS :

DIFFINYEARS (ay_year, now())

but I'm getting an error saying that ay_year field is an integer field in cannot be implemented in this function.

now what would be my options here? obviously it was easier if my users will enter a full date but unfortunately it is not necessary and they actually don't know the full date they know just the year - is there any function which I can extract the year from NOW() function and do a calculated field between two integers?

Thanks

All responses (1)

Answers (0)

Suggested answer

Drew Poggemann 9,079 on at

Like (0)

Report

RE: how to create a calculated field which calculate the difference between years

Hi Alexyou,

This is not possible without the other one being a date field. I would suggest doing this in a workflow and using Jason Lattimer's date utils to accomplish.

jlattimer.blogspot.com/.../updated-crm-workflow-utilities.html

Hope this helps.

Thanks,