Forum Discussion

SushmaReddy's avatar
SushmaReddy
Helper I
4 years ago
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...
  • amitchandak's avatar
    amitchandak
    4 years ago

    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]))

     

amitchandak's avatar
amitchandak
Super User
4 years ago

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]))