Data type Error

[SushmaReddy]

Hi Team,

Written this code to get data from 2 different columns(_Date &_Time)

PTS =

date(Year(T1[_Date]),month(T1[_Date]),DAY(T1[_Date]))

&" "&

time(HOUR(T1[_Time]),MINUTE(T1[_Time]),SECOND(T1[_Time]))

I am getting the below error

**Cannot convert value '21-02-202204:31:56' of type Text to type Date**

Please help me resolve this

[amitchandak · Accepted solution]

@SushmaReddy , Try like

T1[_Date] + T1[_Time]

or

date(Year(T1[_Date]),month(T1[_Date]),DAY(T1[_Date]))
+
time(HOUR(T1[_Time]),MINUTE(T1[_Time]),SECOND(T1[_Time]))