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.

[Sohail Khilji]

Hi @matthew_hughes ,

try using .getDisplayValue();  in your function return. That must help...

[matthew_hughes]

Hi @Sohail Khilji  I've tried the following and it doesn't work:

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') {

return startDate.addYearsLocalTime(3);

}

else if (amaRating == 'moderate') {

return startDate.addYearsLocalTime(2); 

}

else {

return startDate.addYearsLocalTime(1);

}

[Sohail Khilji]

example :

else {
var s_Date = startDate.addYearsLocalTime(1);
return s_Date.getDisplayValue();
} 

[Arun_Manoj]

Hi @matthew_hughes ,

please try like this

var ScopingComplete= new GlideDateTime(ScopingCompleteDate);

//Add one year to the date

if(amaRating=='basic'){

ScopingComplete.addYears(1);

return ScopingComplete.getDisplayValue();}