Discussions

 View Only
  • 1.  How to display current year from date created field?

    Posted 03-22-2018 14:41
    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


  • 2.  RE: How to display current year from date created field?

    Posted 03-22-2018 14:47
    Year(ToDate([Date Created])) = numeric field


  • 3.  RE: How to display current year from date created field?

    Posted 03-22-2018 14:50
    As it is based on date created it won't change when the year changes to 2019, correct? 


  • 4.  RE: How to display current year from date created field?

    Posted 03-22-2018 14:47
    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?


  • 5.  RE: How to display current year from date created field?

    Posted 03-22-2018 14:52

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



  • 6.  RE: How to display current year from date created field?

    Posted 03-22-2018 14:56
    Thank you for the quick response Evan and Chris.