Workflow Trigger based on startDate

[sindhu_v_murthy]

I am trying to build a workflow with trigger as “Identity Created”, currently we have one static “startDate” attribute and we have "actualStartDate" attribute which displays the currentdate and we have done this by using trasform with expression as now.

I am using this below Identity Created trigger and its filter as below

I see that startDate of the user will have to refresh and only when the refresh happens correctly at actualStartdate value, this workflow is gets triggered. So is the system not able to handle this condition? Is there any other workaround for this?

Could you please help me with this issue and suggest me more information about the same?

Thanks,
Sindhu V Murthy

[atarodia (Animesh Tarodia)]

Hi @sindhu_v_murthy,

Could you kindly provide more details regarding your use case? It would be helpful to understand the specific objectives you are aiming to achieve and the challenges you are currently encountering.

[sharvari (Sharvari Shah)]

Hi Sindhu,

If I understand your requirement correctly, you are looking to execute the workflow only when user Start Date = Today (now). If that is correct, the Identity Attribute Created trigger may not work as expected because it is fired on the date the identity record is created in IDN, it may or may not be the same day as today.

One of the options you can try is using a Scheduled Trigger which will fire everyday. You can then find the list of identities that have start date as today and then process them in a loop.

[sindhu_v_murthy]

Hi @atarodia I want workflow to be triggered based on startDate.
Suppose if identities are created today and their startDate is set to some future date.
I need workflow to be triggered on that startDate.

[sindhu_v_murthy]

Hi @sharvari @atarodia ,

Thank you so much for suggesting me, but I still have this question on “actualStartdate” attribute which is calculated from “now” expression, that for example
my startDate attribute value is “2023-07-18T17:44:29.072695Z” of identity1 and
my actualStartdate attribute value is “2023-07-18T08:12:40.967933Z” (got this value from the below transform)

However for the conditions (actualStartdate == startDate) to match “actualStartdate” attribute value should be same as “startDate” attribute value even the seconds of time should match. But actualStartdate value will be updated to new current time only when refresh happens on the identity profile and if refresh happens on the same time as startDate both attribute matches. How to proceed with this?

[sharvari (Sharvari Shah)]

You can format the date to MM-dd-yyyy for both attributes and use that for comparison.

[atarodia (Animesh Tarodia)]

@sharvari

You can format the date to MM-dd-yyyy for both attributes and use that for comparison.

That or you can use the search query as attributes.startDate: [now TO now/d] OR attributes.startDate: [now/d TO now]

That way, you won’t require two attributes and can trigger the workflow whose startDate is today irrespective of time.

[sindhu_v_murthy]

With now I am getting current date value as “2023-07-17T09:41:42.715970Z”
With now/d I am getting value as “2023-07-18”
Is there something I need to be aware of?

[atarodia (Animesh Tarodia)]

If you are doing now/d in a transform and optional attribute roundUp is true, then you will see that date will be rounded up to next date. If you remove the roundUp flag from your transform or set the flag roundUp be false, then you will see the output as 2023-07-17

[sindhu_v_murthy]

Thanks a ton i have applied the same. But now i am trying to test date for one user whse startDate and actualStartdate is same.as in below ss

and Compare Timestamps step is configured as below

But everytime this step is ending with End Step.Is there any config i am missing?

[atarodia (Animesh Tarodia)]

I see that your startDate and actualStartdate are not in ISO8601 format. Both dates needs to be in ISO8601 for the operator to work correctly

[sharvari (Sharvari Shah)]

If you don’t want to convert both to ISO8601 format, use the Compare Strings Operator.

[sindhu_v_murthy]

Understood! I got it worked, a big thanks to both of you for helping me here

[derek_putnam]

If you would be so kind, please mark the solution that best answers your question

[sindhu_v_murthy]

yes, sorry for taking long just missed these notifications.