Adding months/years to the actual date

[Haris Becic]

Hello,

i have one question regarding adding months/years to the specific field. I have the Data Picker field with the name "Received calibrated" and i want to add 2 years in the post function to this field? If this field is empty (User does not give anything in the field) in the transition it takes the today data. How can i do it please? thanks

[Fidel Castro Armario]

Hi @HareCar,

You should use Mathematical and date-time expression calculator with the following formula:

addYears({nnnnn} != null ? {nnnnn} : {00057}, 2, LOCAL) 

replacing nnnnn with field code of Received calibrated custom field.

Note that {00057} is code for numerical value of Current date and time.