>Right you are. That'll teach ME to spew something off the top of my head. . .
>
>JR
>
>>Shouldn't it be 365.25?
>>
MyDOB ={^1963-08-30}
>>? ROUND( (DATE() - MyDOB) / 365.25, 1)
>>
>>
>>
>>>Are you sure your dob field is truly a date field? It seems that you should have gotten the number of days since the dob with that command (not what you were after, but better than an error).
>>>
>>>Do this
>>>MyDOB ={^1963-08-30}
>>>? (DATE() - MyDOB) / 364.25
>>>
>>>That should give you what you want.
>>>
>>>JR
>>>
>>>
>>>>How can I create an expression in expression builder to get a age of person based on their date of birth. For example:
>>>>
>>>>Dob Age
>>>>10/25/44 53.4
>>>>
>>>>
>>>>I tried the expression (date()-person.dob) but it gave me an error as Ambigious date/datetime contstant. Is it even possible to find number of years and months in expression
>>>>
>>>>
>>>>Thanks
>>>>Nick Patel
It worked, thank you for your help
Nick Patel