Can someone show me how I can get the Expiry Date on a form to automatically fill with a date five years after whatever someone plugs into the Effective Date field?
You can set calculation for the Expiry Date as "=ADD_MONTHS(Effective_Date_field,60)" which will add 5 years based on the Effective Date field.
Perfect! Thanks, Xiuhong!
hi,
I'm attempting the same thing but in a collection. I want the expiration date to be 10 years from manufacture date. When I use the field name, I get this:
I've also tried it with the actual variable, like this:
and get the same error.
Any help would be greatly appreciated.
Donnie
I'm not good at this, but I do know that because you have it in a table, you're going to need the extra coding that allows it to do this per row. I've attempted to get it, but I don't have it quite right yet. Maybe someone with more experience in this can help?
=ADD_MONTHS((VALUE(INDEX(ppe.ppe1_helmetmfrdate,120), ROW())))
You can use formula as following:
=ADD_MONTHS(INDEX(PPE.Helmet_Manufacture_Date, ROW()),120)
Thanks for the assistance on this, it works perfectly!
Thank you!!!!