Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
8 years ago

How to display current year from date created field?

I want to display current year, from date created field. I have a formula date field but it gives me an error on the formula "Year[Date Created]. Also I need to know this 'Year' field which i create won't change when the year changes. Thanks
APIs and custom code
App builders
Ask about Quickbase functionality
    • RajHelaiya's avatar
      RajHelaiya
      Qrew Captain
      8 years ago
      As it is based on date created it won't change when the year changes to 2019, correct? 
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    8 years ago
    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

    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?
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago

    Raj

    The formula reflects the year value in the [Date Created] field. Since the value in [Date Created] never changes, the formula will never change as it mirrors the year in [Date Created].