Use Date Function on Set Field

HelpDesk SharePoint 2013/2016 version
1

Hi Everyone.-
I want to see if it's possible to use Set Field to add a Date Field with a DateTime function, i need something like this:

Screenshot_9
Screenshot_9.png1000×268 8.5 KB

Thanks in Advance, Best Regards.

2

Hello, Mario.

Unfortunately, functions are available for conditions only. I would advise you to create a calculated date/time column with the following formula:
=DATE(YEAR([Created]),MONTH([Created]),DAY([Created])+2)

Hide it and in the trigger, set the "Due date" column to the value of the calculated column with the token {{Ticket.Calculated}} where "Calculated" is an internal name of the calculated column.

3

Thanks, going to try that solution soon.
Have a Good Day.

1 Like