Forum Discussion
Solved
Data type Error
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
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]))
1 Reply
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]))