Forum Discussion

EVEAdmin's avatar
EVEAdmin
Icon for Post Patron rankPost Patron
7 years ago
Solved

Convert Year-Month to Full date

Hi all,

 

is it possible to convert a column with Year-Month to a full date?

For example:

2019-05 convers to 01/05/2019

Need Help
  • Gordonlilj's avatar
    Gordonlilj
    7 years ago

    Hi,

     

    You could create a calculated column and use this code

    FORMAT(Table[Column],"yyyy-MM-DD")

1 Reply

  • Gordonlilj's avatar
    Gordonlilj
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi,

     

    You could create a calculated column and use this code

    FORMAT(Table[Column],"yyyy-MM-DD")