Forum Discussion

waleed111's avatar
waleed111
Icon for Helper V rankHelper V
6 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-xicai's avatar
    v-xicai
    6 years ago

    Hi waleed111 ,

     

    You may make sure the data type of 'All Manufacturings (4)'[Added Time] is Date or Date/Time, what's more, this date column should have at least Year, Month and Day level in it, for example like the format "9/20/2020".

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi waleed111 ,

 

You may make sure the data type of 'All Manufacturings (4)'[Added Time] is Date or Date/Time, what's more, this date column should have at least Year, Month and Day level in it, for example like the format "9/20/2020".

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.