Forum Discussion

mattthew's avatar
mattthew
Frequent Visitor
7 years ago
Solved

Date does not convert correctly (Text)

Date

Jan-15

Feb-15

Mar-15

Apr-15

May-15

Jun-15

 

Newbie here.....

Date column listed as text when converting to Date I get 01/15/19, 02/15/19, etc....

How can this convert without adjusting the years to days??  Thanks.

  • Month/Date = FORMAT(Table1[Attribute], "MM/YYYY")
     
    did the trick..

1 Reply

  • mattthew's avatar
    mattthew
    Frequent Visitor
    Month/Date = FORMAT(Table1[Attribute], "MM/YYYY")
     
    did the trick..