Converting string date into ISO8601 date in workflows

[Tulasi (Tulasi Sowjanya Pallaprolu)]

Hi all,
I am facing An issue like I need to compare my startdate using The comparetimestamp operator but my startdate is in string format is there a way to convert the startdate from string to ISO8601 format in the workflow, Any suggestions will be helpful

Thank You

[Abhinov7 (Abhinov Dhonthula)]

Hi,

You can create one more identity attribute and convert the date into ISO8601 format in that identity attribute.

You can use the newly created identity attribute for date comparison in workflows.

-Abhinov

[Tulasi (Tulasi Sowjanya Pallaprolu)]

The thing is we are getting this date from the external trigger

[Abhinov7 (Abhinov Dhonthula)]

Hi,

You can try using the variable.

In variable use the date formatter, or you can use the transform as well. Exactly not sure if it works but you can give a try.

-Abhinov

[Tulasi (Tulasi Sowjanya Pallaprolu)]

yes tried but it didn’t work it is expecting the input in the ISO8601 format

[Abhinov7 (Abhinov Dhonthula)]

Hi,

Can you send me the format of date you are getting from external trigger?

-Abhinov

[Tulasi (Tulasi Sowjanya Pallaprolu)]

it is MM/dd/YYYY format

[Abhinov7 (Abhinov Dhonthula)]

Hi,

If your date format from external trigger is always fixed then you can split and convert the date to ISO format and use it.

I created a skeleton of workflow for you.

You can refer this.

-Abhinov
test20241019.json (4.6 KB)

[Tulasi (Tulasi Sowjanya Pallaprolu)]

Thanks Abhinav it worked.