Matthew R White Posted February 2, 2015 Share Posted February 2, 2015 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 Link to comment Share on other sites More sharing options...
David Jondreau Posted February 2, 2015 Share Posted February 2, 2015 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 ) Link to comment Share on other sites More sharing options...
LaRetta Posted February 3, 2015 Share Posted February 3, 2015 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. ;-) Link to comment Share on other sites More sharing options...
LaRetta Posted February 3, 2015 Share Posted February 3, 2015 I should have indicated that it is a close parenthesis needed before the minus. :^/ Link to comment Share on other sites More sharing options...
Lee Smith Posted February 3, 2015 Share Posted February 3, 2015 Date (1; 1; Year ( Get(CurrentDate) ) -age in years ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3368 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now