YEAR and MONTH function

[waleed111]

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?

[v-xicai · Accepted solution]

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.

[ryan_mayu]

@waleed111 

if you only have year value, then that's not a date. you can only set it to number or text.