Forum Discussion

waleed111's avatar
waleed111
Helper V
5 years ago
Solved

YEAR and MONTH function

i write this formula: Year A = YEAR('All Manufacturings (4)'[Added Time]) but when i try to covert it to date type it show wrong value, it show me 1900 for all value, what is the problem?
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, waleed111 

    I can reproduce your issue here.

    I guess that you column "Year A" is of type "DATE".

    As mentioned in this document ,function "Year"  returns the year of a date as a four digit integer in the range 1900-9999.

    It is suggest to convert your column  "Year A" to type "text"  

     

    Best Regards,
    Community Support Team _ Eason

waleed111's avatar
waleed111
Helper V
5 years ago

when i use:

Year A = format('[Added Time],"YYYY")

it show me this error: cannot convert value to date.

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, waleed111 

I can reproduce your issue here.

I guess that you column "Year A" is of type "DATE".

As mentioned in this document ,function "Year"  returns the year of a date as a four digit integer in the range 1900-9999.

It is suggest to convert your column  "Year A" to type "text"  

 

Best Regards,
Community Support Team _ Eason