Forum Discussion

i820017's avatar
i820017
Icon for Resolver II rankResolver II
4 years ago
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...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    oh....!!! This should work now. 🙂

    Column = IF(ISBLANK('Table'[Column1]),BLANK(),FORMAT(DATEVALUE('Table'[Column1]),"YYYYMM"))

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi i820017 ,

 

Please try below:-

Column = FORMAT(DATEVALUE('Table'[Column1]),"YYYYMM")

 

Thanks,

Samarth

i820017's avatar
i820017
Icon for Resolver II rankResolver II
4 years ago

I used DATEVALUE, and I still get an error.