adding Date

[sumita_de]

HI,
I need to add 7 days to a date.

My requirement is that during the workflow process i need to update a date fields by adding n days to the existing date value. CAn anyone please reply back..its very very urgent!!

Thanks

[shyamala_velan]

Hi,

As per you rquery I suppose the following will be adequate for you.

Description:
I need to create a workflow that will add 150 days or 30 days to a date field.

On my Update operation, I have the following on the field section:

Field Name: Suspended Date
Type: Expression
Value: [&Match Date] + 30

I run the process on the simulator and get the following error: "The value "30" cannot be converted to a date time value."

What is the correct syntax?

--------------------------------------------------------------------------------
Resolution
Comment :
For the benefit of other users, the customer wanted to configure a Workflow Process to add 30 days to a date field. In the above example, the customer was updating a date field called Suspended Date by using a process property called Match Date to add the 30 days to it. When the customer tested their workflow process in the process simulator, they received the error:

The value '%1' cannot be converted to a date time value.

In this case the '%1' was replaced with the number 30.

The reason why the process simulator was reporting this error was because the process property called Match Date was defined with a Data Type = String rather than Date. Once the customer corrected the Data Type for the process property, the simulator was successful in adding the 30 days to the Suspended Date field.

For the Data Type definitions of the process properties, review the Siebel Business Process Designer Administration Guide, Version 7.5, Rev. A, chapter titled Designing Workflow Processes, section titled “Using the Process Properties View”.


Thanks