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

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"))

     

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

      This worked...thanks!!