This Script Error and me are about to fight:
{"ty...
# generalj
Jeff Jacobs
08/22/2024, 5:56 PMThis Script Error and me are about to fight:
{"type":"error.SuiteScriptError","name":"INVALID_FLD_VALUE","message":"Invalid date value (must be M/D/YYYY)
I've tried:
var formattedDate = format.format({value: previousSunday,type: format.Type.DATE});customRecord.setValue({fieldId: 'custrecord_nr_ttl_week',value: previousSunday});var formattedDate = (previousSunday.getMonth() + 1) + '/' + previousSunday.getDate() + '/' + previousSunday.getFullYear();a
ASH
08/22/2024, 6:12 PMvar formattedDate = (previousSunday.getMonth() + 1) + '/' + previousSunday.getDate() + '/' + previousSunday.getFullYear();
After this, add this line:
formattedDate = new Date(formattedDate)
j
Jeff Jacobs
08/22/2024, 6:13 PMAlright let me give this a shot, NetSuite is being a fickle mistress right now
Jeff Jacobs
08/22/2024, 6:18 PMnope still hates us
{"type":"error.SuiteScriptError","name":"INVALID_DATE_VALUE_1_MUST_MATCH_2","message":"Invalid date value Sun Aug 18 000000 PDT 2024 (must match M/d/yy)
Jeff Jacobs
08/22/2024, 6:19 PM// Manually format the date as M/D/YYYYvar formattedDate = (previousSunday.getMonth() + 1) + '/' + previousSunday.getDate() + '/' + previousSunday.getFullYear();// Convert the formatted date string back to a Date objectformattedDate = new Date(formattedDate);Jeff Jacobs
08/22/2024, 6:22 PM@ASH I got it, whew
a
ASH
08/22/2024, 6:22 PMHow😆
j
Jeff Jacobs
08/22/2024, 6:23 PM Copy code
// Get the previous Sunday date
var today = new Date();
var dayOfWeek = today.getDay();
var previousSunday = new Date(today.setDate(today.getDate() - dayOfWeek));
// Strip time from the date
previousSunday.setHours(0, 0, 0, 0);Jeff Jacobs
08/22/2024, 6:24 PMimage.png
a
ASH
08/22/2024, 6:24 PMCongrats .. and thanks for sharing the solution. Might help me in future.🙏
j
Jeff Jacobs
08/22/2024, 6:24 PMDon't thank me, thank ChatGPT lmao
🤣 2
Jeff Jacobs
08/22/2024, 6:45 PMNow I just need to get this other script working for field calculations
Jeff Jacobs
08/22/2024, 7:29 PMNow I have a client script I can't even get to trigger and show any logs
17 Views