I have set up a calculated formula field to calculate the date between a start date and a specified period of months to calculate a renewal date where we have the information.
My problem is that when one of the fields is left empty the calculated field, the renewal date, is coming up with all sorts of crazy dates as it does not have the info it needs. I need to set it up so that if one of the fields is blank is returns no date and comes back blank.
I have tried various formulas with no luck just wondering if anyone can help?
Thanks!
0 commentaires:
Enregistrer un commentaire