Workflow error in dateTime

[chandramohans27 (Chandra Mohan S)]

Hi,

I trying to add 10 additional days from certification activated date and to set that as due date.
I’m receiving the below error while testing my workflow, pasting my step input.

{
  "variables": [
    {
      "name": "TESTING",
      "transforms": [
        {
          "id": "sp:transform:addTime:time",
          "input": {
            "length": 10,
            "type": [
              "string"
            ],
            "unit": "days"
          }
        },
        {
          "id": "sp:transform:concatenate:string",
          "input": {
            "type": [
              "string"
            ],
            "variableB": "_Test"
          }
        }
      ],
      "variableA.$": "$.trigger.campaign.modified"
    }
  ]
}

Error => addTime transform: variable A must be valid sp:transform:addTime:time must be in ISO8601 format

[atarodia (Animesh Tarodia)]

Hi @chandramohans27,

Currently there is an issue with using two operator in single “Define Variable”. I would suggest you to create multiple “Define Variable” to accomplish the requirement.

[atarodia (Animesh Tarodia)]

Here’s more information on the issue:

Workflows Define Variable

Another thing to notice is only second operator is running. It is not taking the value from first operator For example, If second operator is “Trim” → Output: "" If second operator is “Concat” and variable B is “test” → Output: "test" Essentially, the second operator is not able to do operations on first variable, i.e, Variable A .

[chandramohans27 (Chandra Mohan S)]

@atarodia

I’m using single operator “DEFINE VARAIBLE” to add 14 days to the campaign modified date. but it throws the following error in workflow testing.

error :

[atarodia (Animesh Tarodia)]

Hi @chandramohans27,

I am assuming the trigger you are using is “Campaign Generated”, in that scenario the modified date can be null. Is there any reason you are using the modified date and not created date.

Could you please confirm if modified date is not null

[chandramohans27 (Chandra Mohan S)]

@atarodia

I’m using “Campaign Activated” as my trigger.

My requirement is to check for campaign activated date and to add 14 days and keep that in a variable. I dont see any attribute like activated date, hence i’m using modified date, considering thats going to be same when the campaign activated is triggered.

i will be using that variable to set my new deadline to the campaign

[atarodia (Animesh Tarodia)]

Hi,

I just tested this and it is working fine for me.

The reason you are getting this error is because when you are testing the workflow, you are giving the modified attribute null value. When the workflow actually runs, the modified is not null and the date of activation will come.

Try this as workflow test input:

{
  "campaign": {
    "id": "2c91808576f886190176f88cac5a0010",
    "name": "Manager Access Campaign",
    "description": "Audit access for all employees.",
    "created": "2021-02-16T03:04:45.815Z",
    "modified": "2023-07-15T03:04:45.815Z",
    "deadline": "2021-03-16T03:04:45.815Z",
    "type": "MANAGER",
    "campaignOwner": {
      "id": "37f080867702c1910177031320c40n27",
      "displayName": "William Wilson",
      "email": "[email protected]"
    },
    "status": "ACTIVE"
  }
}