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 used DATEVALUE, and I still get an error.
i820017 Please try this:-
Column =
var result = FORMAT(DATEVALUE('Table'[Column1]),"YYYYMM")
return IF(ISBLANK(result),BLANK(),result)I justs did that, and I am still getting the same error.
oh....!!! This should work now. 🙂
Column = IF(ISBLANK('Table'[Column1]),BLANK(),FORMAT(DATEVALUE('Table'[Column1]),"YYYYMM"))This worked...thanks!!