Forum Discussion

mammifero's avatar
mammifero
Frequent Visitor
8 years ago
Solved

date conversion from text

Good Morning to everyone from Italy apologize for my bad English   i ask for a help or a suggestion. at the end of every month i export from my datawarehouse to Excel two tables with sales inform...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    mammifero

     

    You can add a New Column for example

     

    Column =
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Write this calculated column formula

     

    =1*("1/"&[MonthNumber]&"/"&[Year])

     

    Format this column as Date.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

mammifero

 

You can add a New Column for example

 

Column =
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )