Forum Discussion
EvanMartinez
8 years agoModerator
Hi Raj,
Most likely you are getting that error message because you don't have parenthesis around the field name to show that you want the year function to effect it. I would suggest trying
Most likely you are getting that error message because you don't have parenthesis around the field name to show that you want the year function to effect it. I would suggest trying
Year(ToDate([Date Created]))If you do then that formula field will reflect the year that the record was created and will not change. You would also want to make sure it will match the field type that you are using. Are you attempting to put it into a formula date or formula numeric?