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-xicai's avatar
    v-xicai
    5 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.

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    5 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.