Hello,

I have 2 field in my form:
1. a Date/Time field.
2. a Time field.

I want to sum up the two so in the end I'll have a Date/Time field which will hold the value of 1+2 (The date from 1 plus the hours from 2).

I have no idea how to sum up the two.
Can you help? (This is quite urgent for me..)

Thanks ahead!

Read the section in the Advanced Admin Guide on "Using Business Time in the AR System Server". There are a whole series of commands you can use to get to what you need.

First of all thanks..
But by the explanation there I realized that you can add days with the $PROCESS$ Application-Bus-Time-Add, but I want to add hours..
How do I do that?

Make sure to set the Offset Units to hours.

OffsetUnits—Unit of time. It can be set to 1 for seconds, 2 for minutes, 3 for hours, and 4 for days. Any other setting will revert to hours (3).

Got it. Thanks alot!!

No problem! Good luck!

Hello again,

I've tried performing the following action inside an Active Link:
$PROCESS$ Application-Bus-Time-Add "08/08/2006 09:00:00" "1"
and put it in a Date-Time field.
However, the Remedy User puts out an error:" Set fields active link running a process failed (ARERR 1603)".

Can you tell me what am I doing wrong? (I've also tried putting only the date without the time, but still the same error occurs)

Thanks ahead

Hi,

You must use UNIX timestamp date format with this process.

What is the UNIX timestamp? What if I want a field named "nnn" of type Date-Time to be instead of the timestamp?

You have to use @@: before the process, because it is a server process:

$PROCESS$ @@:Application-Bus-Time-Add

Nevermind, I managed to solve it.
Thanks!!

You can use Date/Time field because these fields are stored in the UNIX timestamp format in the database.

The UNIX timestamp is the number of seconds between your date and the 01/01/1970.