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.

 

 

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

    i820017 Please try this:-

    Column = 
var result = FORMAT(DATEVALUE('Table'[Column1]),"YYYYMM")
return IF(ISBLANK(result),BLANK(),result)
    • i820017's avatar
      i820017
      Icon for Resolver II rankResolver II
      4 years ago

      I justs did that, and I am still getting the same error.

       

       

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

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

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