Formulaic print date 1

[ImArchimedes]

So, I've written a formula to determine age of a person. The only piece I'm missing is the current date to run against the date of persons birth. I know how to pull the printdate field into a report by it's self but does anyone know how I would pull that into a formula? Thank you for your help.

 

[AndyMc]

In the formula editor, under Date & Time functions you can find 'CurrentDate' function.

In the formula editor, under Document Properties functions,
you can find others like PrintDate, DataDate, ...

Andy

 

[chelseatech]

What formula did you use to calculate the age? There are several out there that don't work as accurately as they should. The one we recommend is
if Month({Birthdate}) < Month(CurrentDate) OR
(Month({Birthdate)) = month(CurrentDate) AND
Day({Birthdate)) <= Day(CurrentDate)))
Then Year(CurrentDate) - Year({Birthdate})
Else Year(CurrentDate) - Year({Birthdate}) - 1

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm