reverse calc for date

[Matthew R White]

I'm looking to create a calc that takes a number say age field = 36 and reverse calculates it to get a date of birth for that age, say 1/1/1971. All of the month and date fields will stay 1/1/ only the year field will end.

 

Thoughts?

 

Matt

[David Jondreau]

I think you're going to want to revisit your requirements once you start using it, but this should get you the results you're asking for:

 

Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) - table::AgeInYears )

[LaRetta]

It will ... if you add another parenthesis before your minus. :-)  And you obviously know that.  I did just such a typo just few days ago. ;-)

[LaRetta]

I should have indicated that it is a close parenthesis needed before the minus.  :^/

[Lee Smith]

Date (1; 1; Year ( Get(CurrentDate) ) -age in years )