Subtract Date and time

[Luukvb]

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?

[MichalM · Accepted solution]

@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")

[Luukvb]

It is working, thanks!