Hello Guys,
While formating the date using .format...
# suitescripta
AB
07/26/2021, 10:38 PMHello Guys,
While formating the date using .format function in SuiteScript 2.0, I am getting error "INVALID_TYPE_1_USE_2".
How can I resolve it?
b
battk
07/26/2021, 11:03 PMshare the code
a
AB
07/26/2021, 11:17 PMtry {
log.debug('DEBUG','startDate: ' + startDate);
var splitBlank = startDate.split(' ');
log.debug('DEBUG','splitBlank[0]: ' + splitBlank[0]);
var splitData = splitBlank[0].split('-');
log.debug('DEBUG','splitData[0]: ' + splitData[0] + ' :: splitData[1]: ' + splitData[1] + ' :: splitData[2]: ' + splitData[2]);
var nsDate = [splitData[1],splitData[0],splitData[2]].join('/');
log.debug('DEBUG','nsDate: ' + nsDate);
var parsedDateStringAsRawDateObject = format.parse({
value: nsDate.trim(),
type: format.Type.DATE
});
log.debug('DEBUG','parsedDateStringAsRawDateObject: ' + parsedDateStringAsRawDateObject.toString());
var formattedDateString = format.format({
value: parsedDateStringAsRawDateObject,
type: format.Type.DATE
});
log.debug('DEBUG','formattedDateString: ' + formattedDateString.toString());
return [parsedDateStringAsRawDateObject, formattedDateString];
} catch(e) {
log.error('ERROR','Exception in date: ' + e.toString());
}
b
battk
07/26/2021, 11:21 PMone of the weaknesses of format.parse is that it outputs the input if the input is invalid
battk
07/26/2021, 11:22 PMare you sure parsedDateStringAsRawDateObject is a Date
battk
07/26/2021, 11:23 PMyou are probably wasting your time using both parse and format, the two are inverses of each other
a
AB
07/26/2021, 11:34 PM@battk When I select few records from csv file and create a new CSV file, then importing that file in NetSuite via SuiteScript, getting date format "DD-MM-YYYY".
But when I imported the CSV file which was given by the client than getting date value in "YYYY-MM-DD" format.
Can you please let me know why I am getting different format?
AB
07/26/2021, 11:35 PMmessage has been deleted
b
battk
07/26/2021, 11:36 PMexcel has date formatting preferences
battk
07/26/2021, 11:36 PMuse a text editor to look at the raw output
a
AB
07/26/2021, 11:45 PMCorrect... thanks @battk
b
battk
07/26/2021, 11:48 PMthe usual recommendation is using moment timezone to format your string into a Date
👍 1
battk
07/26/2021, 11:48 PMN/format is only good for strings to go to and from netsuite
a
AB
07/27/2021, 12:06 AMOkay
2 Views