Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How can I change data type in ssdt directly?

Hi All,

 

Am creating a New SSAS Tabular Project in SSDT. Is that possible to change data type from text to date directly in SSDT?

 

 

 

 

 

  • Hi Anonymous 

     

    In the model designer, select the column for which you want to change the data type or display format. In the column Properties window, do one of the following: In the Data Format property, select a different data format. In the Data Type property, select a different data type.

     

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

     

    In the model designer, select the column for which you want to change the data type or display format. In the column Properties window, do one of the following: In the Data Format property, select a different data format. In the Data Type property, select a different data type.

     

  • Anonymous , you can change the data type to date.  If it does not work then you have to create a new column and create a date using various datepart from text.