Updating a date field in Flow Designer

[matthew_hughes]

I'm trying to update the 'Next AMA Due Date' field in my flow designer based on the following requirements:

• If Enhanced = Date Scoping Completed + 1 Year
• If Moderate = Date Scoping Completed + 2 Year
• If Basic = Date Scoping Completed + 3 Year

I'm trying to implement the requirements with the following code:

However, what I'm finding is that it doesn't update the 'Next AMA Due Date' field with the required date. I ran some logs for the 'scopingCompleteDate' and 'amaRating', but nothing is returning to the logs. I was just wondering if somebody has come across this before and what I can do to resolve it.

[Amit Verma]

@matthew_hughes 

Use below syntax :

fd_data._2__look_up_record.record.<your-field-name>;

Once you start typing in the script pane, it will prompt you for the fields.

Thanks & Regards

Amit Verma

[Arun_Manoj]

Hi @matthew_hughes ,

var scopingCompleteDate = current.getDisplayValue('u_last_scoping_ama_completed_date');

gs.log('MH: The value of the scopingCompleteDate is: ' + scopingCompleteDate);

var startDate = new GlideDateTime(scopingCompleteDate);

var amaRating = current.getDisplayValue('u_access_management_controls');

gs.log('MH: The value of the amaRating is: ' + amaRating);

if (amaRating == 'basic') {

startDate.addYearsLocalTime(3);

}

else if (amaRating == 'moderate') {

startDate.addYearsLocalTime(2); }

else {

startDate.addYearsLocalTime(1);

} // Return or set the new date to the desired field in the current record

return startDate;

You can appreciate this reply by hitting HELPFUL or CORRECT .

[Deborah Brown L]

Hi @matthew_hughes,

First you need to know from which flow designer step you are getting the value,

example,

fd_data.trigger.current.sys_updated_on;

fd_data = this is constant to get a value from script

trigger or any step value should be the next object.

then if it is table, then current. if it is variable, then current.variables

lastly it should be the field or variable backend name.

If the value is not from any step, then add a "look up record" or "look up records" flow logic step to get the value of that field.

Regards,

Deborah Brown

Mark the article as helpful and bookmark if you found it useful.

[matthew_hughes]

Hi @Deborah Brown L Unfortunately, that functionality doesn't work in our instance where it automatically appears. 

Hi @Amit Verma  What would be the syntax for getting a field from section 2 and getting a field from within the 'Business Application Record':

[Deborah Brown L · Accepted solution]

Hi @matthew_hughes ,

If 2nd step is where you are getting the value and it is a look up record, then you should use 

fd_data._2__look_up_record_current.<field name>

Regards,

Deborah Brown

Mark the article as helpful and bookmark if you found it useful.