0

Show Date as Year Only

I have a date field named Vintage. How do I format it to only show the year, like 2008?

5 replies

null
    • Ninox developer
    • Fabio
    • 4 yrs ago
    • Reported - view

    Hi

    year(Vintage) or format(Vintage, "YYYY") to Formats a date as a string

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Obviously, I'm not placing the code in the correct place. Where doe it go? I still see the date as Jan 1, 2008

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Screen Shot 2019-08-24 at 3.46.02 PMScreen Shot 2019-08-24 at 3.46.35 PM

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Formula goes in a formula field. A date field itself cannot be changed, just the looks in the calender are changed where you've put your formula in screenshot.

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Got it. Then in my case, I will delete the date field and create a number field. That will work.

Content aside

  • 4 yrs agoLast active
  • 5Replies
  • 1579Views