Need help to convert DateDiff statement into Alteryx from SQL.

[Puneet13]

I have tried to implement below status in Alteryx but it is not allowed to perform the action. Can somebody provide me the solution.

SQL  - convert(varchar(5),DateDiff(s, [RobotStartProcessingTime], [RobotEndprocessingTime])/3600)+':'+convert (varchar(5),DateDiff(s, [RobotStartProcessingTime], [RobotEndprocessingTime])%3600/60)+':'+convert(varchar (5),(DateDiff(s, [RobotStartProcessingTime], [RobotEndprocessingTime])%60)) as Robot_Processing_Time

[ShankerV]

@Puneet13 

Can you please post what is the input and what is the output expected.

That will give more clarity to address the issue.

Many thanks

Shanker V

[Puneet13]

Input - convert(varchar(5),DateDiff(s, [RobotStartProcessingTime], [RobotEndprocessingTime])/3600)+':'+convert (varchar(5),DateDiff(s, [RobotStartProcessingTime], [RobotEndprocessingTime])%3600/60)+':'+convert(varchar (5),(DateDiff(s, [RobotStartProcessingTime], [RobotEndprocessingTime])%60)) as Robot_Processing_Time

Output Needs to Develop in Alteryx, unable to make formula in Alteryx.

[Puneet13 · Accepted solution]

Solution - tostring(DateTimeDiff( [RobotEndprocessingTime],[RobotStartProcessingTime],"hours")/3600) +":" + tostring(mod(DateTimeDiff( [RobotEndprocessingTime],[RobotStartProcessingTime],"minutes"),60 ))+":" +tostring(mod(DateTimeDiff( [RobotEndprocessingTime],[RobotStartProcessingTime],"seconds"),60) )

[Felipe_Ribeir0]

Hi @Puneet13 

Try this, it will work even for 24+ hours of difference: