Let ( [ S = YourNumberStringfield;
Y = Left ( S ; 2 ) ] ;
Date ( Middle ( s ; 3 ; 2 ) ; Middle ( s ; 5 ; 2 ) ; If ( Y > 12 ; 1900 ; 2000 ) + Y )
And you could use Right ( Year ( Get ( CurrentDate ) ) ; 2 ) in place of 12 if you need to use this in future years.
Thank You for your help,
but with 84031202450 i get 724347 in the calculation field
Make sure that you select "date" as the calculation's result type instead of number.
Could You please tell me if I can Have AGE
from currentdate - birthdate calculated from the string above and the Age does not updates as the time pass ?
Thank You very much!
Use the date field calculation to get birthdate as a date, then use this calculation:
Let ( [ B = YourBirthdateField ;
T = Get ( currentdate ) ;
BD = Date ( Month ( B ) ; day ( B ) ; Year ( T ) ) // date of this year's birthday
Year ( T ) - Year ( B ) - ( BD > T )
If you define this in a a calculation field with date selected as the return type (not a date field using this expression as an auto-entered calculaiton) and select "unstored", the age will update automatically as time passes. If you use an auto-enter field or a stored calculation, it will not update.