topic Re: Subtract Date and time in Alteryx Designer Desktop Discussions

Subtract Date and time

Luukvb — Mon, 11 Nov 2019 15:06:26 GMT

Hi,

I have a problem with substracting two dates/times. In the data a format with milliseconds has been used. I want to subtract [Max_INV_Zero_Degree] of [Max_to_shipment]. But the first problem I faced is transforming the string into Can someone help me?

Re: Subtract Date and time

MichalM — Mon, 11 Nov 2019 15:23:55 GMT

@Luukvb

I'd first remove the milliseconds - you can use the formula tool with the below expression to do that.

Replace([Max_to_shipment], Right([Max_to_shipment], 4), "")

Once done, I'd convert the datetime string to a variable in the correct data type using the DateTime parse tool followed by a formula tool calculating the difference. Attached is an example.

DateTimeDiff([Max_to_shipment_NEW],[Max_INV_Zero_Degree_NEW],"seconds")

Re: Subtract Date and time

Luukvb — Mon, 11 Nov 2019 15:30:05 GMT

It is working, thanks!