Forum Discussion

devgian's avatar
devgian
Frequent Visitor
3 years ago
Solved

FORMAT created column to MMM

Hello Everyone, 

I have a created column 

4/17/2023 4:19:06 AM

I created another column and i want this column created to be a month and i used 

Month = FORMAT(tbl[created], "MMM") but it did not change. 

Am i doing it incorrectly?

Thanks in advance for your help

  • Got it. 

    Month = FORMAT(DATEVALUE(tbl[created]), "MMM") 
    //DATEVALUE SOLVES IT 

1 Reply

  • devgian's avatar
    devgian
    Frequent Visitor

    Got it. 

    Month = FORMAT(DATEVALUE(tbl[created]), "MMM") 
    //DATEVALUE SOLVES IT