Create a catalog task based on requested item variables

[Alex Saager1]

I have a requirement to create a catalog task based on a requested item variable:

The catalog item is for users to use when staff are leaving, but the issue I have is that all the tasks are generated at the time of the request being submitted (normal behavior) but in some cases this can be for example a month in the future and then we have tasks sitting in queues for say a month with no action needed.

Is it possible to generate these tasks based on the date used on the catalog form?

So if for example someone is laving on the 01/05/23 then these tasks are created at that time.

Hope this is clear any ideas or suggestions would be greatly appreciated

Thanks

Alex

[Ankur Bawiskar]

@Alex Saager1 

seems the date format is the issue. try to convert it into YYYY-mm-DD

[Alex Saager1]

Hi Ankur,

So I've updated the script as suggested but the tasks are still being generated?

so script now reads:

var terminationDate = current.variables.termination_date.getDisplayValue();

var formatdate = day.getByFormat("yyyy-MM-dd");

gs.info("Termination Date" + terminationDate);

answer = gs.dateDiff(new GlideDateTime(), terminationDate, true);

Alex

[Ankur Bawiskar]

@Alex Saager1 

is that the complete script?

[Alex Saager1]

yes it is, am I missing something?

[Devender Kumar]

Hello,

Please refer the below links.

https://www.servicenow.com/community/developer-forum/generate-a-task-based-on-a-specific-variable-da... 

https://www.servicenow.com/community/developer-forum/workflow-how-to-create-task-at-certain-date/m-p... 

Please mark my answer as helpful/correct if it helps you.

Regards,

Devender