Announcement

Collapse
No announcement yet.

Get Current Year Via Formula

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Get Current Year Via Formula

    Hello.

    Can someone help me on this basic issue? Im trying to get the current year via formula. Below is what Im using

    name=datetime\year(VALUE);

    This did not work. It returns a 0.

    I have reviews the documentation here and can't seem to get it to return 2020.


  • #2
    Hello,

    VALUE must be a date/dateTime attribute (field name).
    you have this to : datetime\now()

    so just need to format : datetime\format(datetime\now(), 'America/New_York', 'YYYY');

    Comment


    • #3
      Thank You item ! That works

      Comment

      Working...
      X