Currently, I am undertaking a project that involves collecting data from an API, storing it in a matrix, and then setting that data in a Google Sheet using the Google-Sheets-APIv4 with Node.js. The two key elements in this API are object.start_date and object.end_date, which return date strings in the format such as "2021-09-22" (yyyy-mm-dd). My objective is to convert this date to the dd/mm/yyyy format. To achieve this, I have implemented the following function:
function changeDateFormat(dateString){
let a=dateString.split('-');
let t=a[0];
a[0]=a[2];
a[2]=t;
//console.log(a.join('/'));
return `${a.join('/')}`;
}
The code works correctly, and I've applied it in the following manner:
let checkin=`${changeDateFormat(`${tenancy.start_date}`)}`;
console.log(checkin);
let checkout=`${changeDateFormat(`${tenancy.end_date}`)}`;
console.log(checkout);
In the above code snippet, tenancy represents an object. The output displayed in the console matches the desired format, confirming that the date conversion algorithm functions appropriately.
Furthermore, my code for adding the data to the sheet is as follows:
await googleSheets.spreadsheets.values.append({
auth,
spreadsheetId,
range:"MySheet!A2:AC",
valueInputOption:"USER_ENTERED",
resource: {values : newData}
/*newData is a 2-D array where each row contains various data fields formatted as newData[i]=[propertyName,id,......,check-in,checkout,.......]*/
});
Nevertheless, upon adding the data to the sheet, the date fields appear scattered - some displaying the preferred dd/mm/yyyy format while others retaining the original yyyy-mm-dd format, as depicted in this image https://i.stack.imgur.com/HvC5F.png
I'm currently unable to identify the issue within the code, even though no errors are apparent. The inconsistency of the output leaves me perplexed, with some cells being correctly formatted while others aren't. Could you suggest a viable workaround for this predicament? I'm willing to offer additional information or code snippets relating to the issue if necessary. Thank you!