Question

Assembly of Date and time

Hello,

For a an object i have a "Start Date" and a "Start Time". Both as seperate fields. I have a third time field "Start Date & time".

The Field for Date and time are populated. Now within a process i want to combine the seperate fields for date and time into the "Start Date & time" field...

Can somebody tell me how this can be achieved?

Like 0

Like

1 comments

Hi!

You can combine the Start Date and Start Time fields in a business process using a Formula element.

Example formula:

AddHours(
AddMinutes([#Start Date#], DatePart("Minute", [#Start Time#])),
DatePart("Hour", [#Start Time#])
)

Then use a Modify Data element to write the result into the Start Date & Time field.

Show all comments