cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EVEAdmin Member
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Gordonlilj Member
Member

Re: Convert Year-Month to Full date

Hi,

 

You could create a calculated column and use this code

FORMAT(Table[Column],"yyyy-MM-DD")
1 REPLY 1
Highlighted
Gordonlilj Member
Member

Re: Convert Year-Month to Full date

Hi,

 

You could create a calculated column and use this code

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