I currently have an auto enter calculation that ensures carried out a check on the year entered to ensure that it is not longer that 10 years ago and is not higher than the current year.
How would i add to this script so that it automatically enters in the current year? I still want the script below to work just in case the user enters in a year that is different to the current year.
@Numbers = GetAsNumber( TextFormatRemove (Filter(Self; "0123456789")));
@Numbers < Year(Get(CurrentDate)) - 10 or //checks that the year entered is not over 10 years ago
@Numbers > Year(Get(CurrentDate)) ; //checks that the year entered is not higher than the current year
TextColor ( Self ; RGB(255; 0; 0)) ;