Workflow: Action "Wait" until, Date format issue

Hi Developers

Hope you are doing good.

Our requirement is to trigger our termination workflow at 5PM est. So we have user “Wait” Action and used Wait until.
Below is our Wait action configuration:

Identity Attribute Value:
image

To change Date to this format we are using below transform:

{
    "id": "37028ee2-f248-4517-9fa3-6e9175bdeeba",
    "name": "Term date testing format",
    "type": "dateFormat",
    "attributes": {
        "inputFormat": "MM/dd/yyyy",
        "outputFormat": "ISO8601"
    },

But at the end we are encounter with below error:
{“displayName”:“Wait”,“error”:“both date: and time: 1970-01-01T17:30:00.000Z could not be empty”,
“stepName”:“wait”,“task”:“sp:sleep”,“technicalName”:“Wait”}
{“error”:“task failed: activity error (type: sp:internal:sleep, scheduledEventID: 5, startedEventID: 6,
identity: 1@sp-workflow-worker-stg-us-east-1-69cd5978b6-nzksv@):
both date: and time: 1970-01-01T17:30:00.000Z could not be empty (type: Error Parsing Input, retryable: false):
both date: and time: 1970-01-01T17:30:00.000Z could not be empty”}

I will highly appreciate your help and time.

Regards
Vatan

This is in your code, [quote=“Vatan Jain, post:1, topic:97524, username:Vatanjain11”]
"inputFormat": "MM/dd/yyyy",
[/quote], but the value is in this format: “yyyy-MM-dd”.

This could be your problem

The variable/attribute has to be in ISO8601 format. This should include the Date and timestamp when the wait step needs to end.

Note- This will work as expected only if you provide the same variable in both the Date and Time fields.

You need to specify time using the same variable as provided in Date using Choose Variable option.

Hi Sharvari

thank you for your response

You meant to say like that :

Please confirm.

Regards
vatan

Hi
the attribute value that you are seeing that is after using the tranform that’s the reason it’s format is different.

Thanks
Vatan

Yes, that’s correct.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.