How to add two variables of type date?

Question

Good afternoon people!

I have a problem and after a lot of research I still don't know how to solve it

I have two variables @travel_time and @trip_duration, where I need to add the hours and minutes of the second to the first and create a new variable called @arrival_time

I didn't see any way to do this operation in ampscript

Does anyone know of a way I can help myself? I've been stuck on this task for 3 days

Example:

%%[
set @data1 = @travel_time 
set @data2 = @arrival_time 
]%%
%%=v(@data1)=%% %%=v(@ data2)=%% 

______________________________________ 
21:00:00.000Z     08:00:00.000Z 
______________________    
04:00:00.000Z     02:55:00.000Z

Answer 1

That should look something like this:

set @hour_offset = DatePart(@trip_duration, "H");
set @minute_offset = DatePart(@trip_duration, "MI");
set @travel_time = DateAdd(@trip_duration, @hour_offset, "H");
set @travel_time = DateAdd(@travel_time, @minute_offset, "MI");

We extract the hours and minutes, then add them consecutively to form the new value. Note that DateAdd returns a new, independent date, so we have to use @travel_time in the second calculation.