Forum Discussion

JennyMilf's avatar
JennyMilf
Helper I
3 years ago

Convert text to Date

Hi everyone, How can I convert Year-month from text to Date?  I tried: YearMonth_Date = DATE(LEFT(Table[YearMonth], 4), RIGHT(Table[YearMonth], 2), 1) but it's not work Thank you    
Need Help
JennyMilf's avatar
JennyMilf
Helper I
3 years ago

How about Month_hoa convert to Date (just show month number)?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    =SWITCH([Month Name],"Jan",1,"Feb",2,"Mar",3,"Apr",4,"May",5,"Jun",6,"Jul",7,"Aug",8,"Sep",9,"Oct",10,"Nov",11,"Dec",12,"Invalid Month")

     
    Try this 🙂 
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi JennyMilf 

    You can refer to the following calculated column:

     

    YearMonth_Date = CONVERT([Year-Month],DATETIME)

Month_num=MONTH(CONVERT([Month_hoa]&" "&"1",DATETIME))

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly