I have created a calculation field to calculate the age of a person based on their date of birth:
(Date.now() - @Date of Birth)/31536000000
If there is no date of birth entered the calculation field is defaulting to 45. Is there a way I can change my calculation to only calculate the age if the date of birth field has been captured, and to leave the calculation field blank if there is no date of birth?
Please sign in to leave a comment.