Skip to main content
Question

How to display current year from date created field?

  • March 22, 2018
  • 0 replies
  • 165 views
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

    • ChrisChris
    • Quickbase Alumni
    • March 22, 2018
    Year(ToDate([Date Created])) = numeric field
    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • March 22, 2018
    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
    • Quickbase Alumni
    • March 22, 2018

    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].

    • RajHelaiya
    • Author
    • Quickbase Alumni
    • March 22, 2018
    Thank you for the quick response Evan and Chris. 
    Terms & ConditionsAccessibility statement