Matthew Cooke

ifElse formular for dates

Discussion created by Matthew Cooke on Oct 20, 2016
Latest reply on Oct 20, 2016 by Sam Roy

HI, I'm looking for some assistance with a formula - ifElse.


The backgound - in the meetings module, there is the end date of the meeting, I also have a drop down which I use to express the length of time a certificate for that meeting is valid - 1 Year, 2 Years, 3 Years. In my candidates module I am trying to get a field that will calculate when their certificate will run out according to the length of time a certificate is valid.

I've been trying and failing to use the ifElse function - can anyone advise


Thanks in advance