[Reference] SharePoint: It is funny to use functions such as today and me in calculated fields, but it is effective.

(Hidden) myvisited Visited counter. Current :( 285)

2007-3-30 SharePoint: It is funny to use functions such as today and me in calculated fields, but it is effective. Raise questions: I have wss3.0 there is a custom list, which is based on an existing column [ Date of Birth ] to calculate [ age ] , the formula = datedif ([ Date of Birth ], today, "Y ") to compute, but it is found that today or mE This function cannot be used in computed columns. I don't know how to calculate the current age?   This problem has been plagued by many friends, but the solution is very funny. It seems that you just lied to SharePoint.   Procedure: Step 1: create a field calledToday, (All types of text are supported) Step 2: Create the field you want to calculateAge, Formula=Datedif ([Date of birth], Today, "Y ")The type is a number. Step 3: deleteTodayField.