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"))
Hi i820017
You can create a column this way, Column = FORMAT ([Date Request Submitted], "YYYYMM" )
And you will get the desired result.