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
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com(941) 743-0108
(800) 246-5488