Forum Discussion

ling0028's avatar
ling0028
Frequent Visitor
9 years ago

Change data type using direct query

Hello,   We are replicating SAP tables through SLT. Date columns in SAP are stored as varchar(8) so SLT converts it on HANA using the same data type.   I'm trying to keep the direct query functi...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

ling0028

 

If your original DATE values have the format like MMDDYYYY (e.g. 07032016), please try to create a new column with following DAX formula. Then try to change the Data Type of this column to Date. Please refer to my following screenshot.

 

DATE = 
LEFT ( 'Change data type using direct query'[DATE_GLTRP], 2 ) & "/"
    & MID ( 'Change data type using direct query'[DATE_GLTRP], 3, 2 )
    & "/"
& RIGHT ( 'Change data type using direct query'[DATE_GLTRP], 4 )

 

Best Regards,

Herbert

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Have you guyz found any solution for this? I am stuck with the same error