Need help to convert DateDiff statement into Alteryx from SQL.

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

Workflow

Datasets

Reporting

Error Message

Regex

Custom Tools

Parse

Macros

Date Time

Server

Transformation

Batch Macro

Fuzzy Match

Dynamic Processing

Join

Spatial Analysis

Preparation

In Database

Interface Tools

Text Mining

Data Investigation

Database Connection

Scheduler

Demographic Analysis

Documentation

Iterative Macro

Prescriptive Analytics

In-Database

Accepted answers

Puneet13

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

All comments

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

Felipe_Ribeir0

Hi @Puneet13

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

Need help to convert DateDiff statement into Alteryx from SQL.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335