Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

CURRENT YEAR ISSUE

Hi, can someone please help me out.. i cant get current year measure right ( image 1).. I can manually input "2023" see image 2 below to test it.. 

Thank you kindly  - Zoey

 

 

 

 

 

 

  • Anonymous .

    Syntax is:

    .....Dates[Year] = Year( Today() )....

    Regards,

5 Replies

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion

    Anonymous .

    Syntax is:

    .....Dates[Year] = Year( Today() )....

    Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable

    works Thank you!! Zoey

  • Anonymous's avatar
    Anonymous
    Not applicable

    rsbin: one more question: is there difference if i use dates[year] = year(now()).. vs "today" ... i noticed "now" same result in this case, but not sure if there is any overall rule in the two.

    thanks again

    Zoey

    • rsbin's avatar
      rsbin
      Icon for Community Champion rankCommunity Champion

      Anonymous ,

      Now() gives you current Date and Time.

      I would stick with Today() since you are only looking for the YEAR.

      Trust this helps.

      Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable

    Yup and shall do thank you

    Z