In my script I'm trying to take the date the record is created, add 10 years to that value and set it in another field. I have tried a number of ways to achieve this and all of them keep returning errors.
In the image below, highlighted are the logs of the 3 ways I have attempted to update the field. The second one appears perfect but still no luck.
This is the unedited version that will return: Tue May 16 2034 00:00:00 GMT-0700 (PDT)
// Calculate the expiration date for the warranty (current date + 10 years)
var currentDate = new Date();
var expirationDate = new Date(currentDate.getFullYear() + 10, currentDate.getMonth(), currentDate.getDate());
// Log the expiration date
log.debug('Expiration Date Attempted to Set: ' + expirationDate);
// Save warranty record
warrantyRecord.save();
After that, I tried to format the date to what I thought was the ideal result of: 16/05/2034
// Format the expiration date as "DD/MM/YYYY"
var formattedExpirationDate = format.format({
value: expirationDate,
type: format.Type.DATE });
And this last one was a suggestion I found on reddit to use the IS08601 formatted date string and returns: 2034-05-16T07:00:00.000Z
// Convert expiration date to ISO 8601 format
var isoExpirationDate = expirationDate.toISOString();
I'm not sure what else to try, any suggestions?