This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi All, I am creating CSV file using suite script. There is a date column of format mm/dd/yyyy. If the date is 11/03/2021, it is showing as 11/3/2021. I put the logic to add zero but it is not working. Is there any way to put the zero?

thank you <@U5TF1GQ20>
var year  = arrayValue[0].substring(0,4);
var month = arrayValue[0].substring(4,6);
month=('0'+month.toString()).slice(-2);
var dt  = arrayValue[0].substring(6,8);
dt=('0'+dt.toString()).slice(-2);
date = year+'/'+month+'/'+dt;

and what is arrayValue[0], and more importantly where does it come from

if it comes from a field or column in netsuite, then the script type matters as well

it comes from CSV file. I read the data from one CSV file and create one new CSV file

while ugly, that code doesn't look like it truncates the 0

or looking at the csv file in a text editor

yes when i open csv file in a text editor it has zero

and their default date format is removing the 0

yes you are correct. when i manually change the column format to (yyyy/mm/dd), it has zero. And i don't think we can set column format via suitescript..right?

no, csv files are far too simple for that

csv has no specifications about how to interpret strings

thats the job of the software reading the csv

if you dont control that software, you need to change file formats