Forum Discussion
Solved
Date to YearMonth Column
I am trying to create a column that takes a date in mm/dd/yyyy and turns it into YearMonth. (The name of the column that I am working with is 'Procedure Request Form'[Date Request Submitted]) For...
oh....!!! This should work now. 🙂
Column = IF(ISBLANK('Table'[Column1]),BLANK(),FORMAT(DATEVALUE('Table'[Column1]),"YYYYMM"))
I am still getting an error.
This is weird because Date Request Submitted is a Date as seen below.