Formatting dates in Google Sheets scripts

As someone with no coding experience, I'm in desperate need of assistance.

Everyday, I receive a scheduled report via email containing updates. To streamline the process, I've utilized a Google Sheets script that imports this report into the sheet. However, the date column (B2:B1551) is formatted as "1st Jul 19," and I require it to be converted to dd/mm/yyyy format automatically. Is it feasible to create a script that converts either column B or creates a new column reading from column B and converting dates to dd/mm/yyyy format?

javascriptfunctiongoogle-apps-scriptgoogle-sheets

Answer №1

Code to Format Array Object Timestamp:

The current code snippet below demonstrates how to set the first array object to a timestamp:

values[0][0] = new Date();

Solution for Formatting Date:

We can utilize Utilities.formatDate() method for formatting the date, with the following syntax:

Utilities.formatDate(date, timeZone, format);

Therefore, the updated code implementation will resemble the code snippet provided below:

values[0][0] = Utilities.formatDate(new Date(), "GMT+0", "dd/MM/yyyy");

References and Documentation:

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Arrange the div elements in a single horizontal line

Is there a way to align the company logo div next to the name, address, email, and phone number containers? I've attempted using display: inline and float: right, but the logo isn't moving up as desired. Here's the code snippet: http://jsfi ...

javascriptjqueryhtmlcss

What is the best way to remove a CSS style using JavaScript?

For my website automation using Selenium, I encountered a challenging dropdown that was not the standard native one but a custom-designed version. To tackle this issue, I needed to set its CSS class to hidden in order to access the native functionality smo ...

javascriptjquerycssseleniumselenium-webdriver

`Dynamic assortment displaying menu`

I am currently developing a compact application that requires a list of 5 items: Name Address City Country Zipcode Whenever a user clicks on any of these items, they should be redirected to another page where that specific item is highlighted. ...

javascripthtmlcss

Locate all the small values within a given array

I am working on an application that involves gathering input from users for ten questions using select drop down boxes. The values range from 1 to 5 for each question. Upon clicking the submit button, I collect all the input values and store them in an obj ...

javascriptexpress

Modify the attribute of numerous elements when hovering by implementing CSS transformations

I have a pair of adjacent div elements and I want to modify the background-color attribute of both when the user hovers over one of them. Initially, both divs should have a background-color set to #d8d8d8, and this color should change to #cacaca on both d ...

javascriptjqueryhtmlcss

Creating your own data frames by using the 'function' method

Dealing with a very extensive data frame, I am looking to extract smaller data frames based on specific conditions. However, I'm struggling with finding an effective method to do so. The data frame structure is similar to the following (albeit with nu ...

rfunctiondataframe

The Angular filter is waiting for the ng-repeat to be populated

I have a filtering system that includes dropdown options to filter the displayed content. The content is fetched from a database and takes a few milliseconds to display. During this time, I encounter several errors related to the filtering system. Does any ...

javascriptangularjsangularjs-ng-repeat

Reveal the array on the frontend in a row each time using Javascript

My array contains the following items: let array=["First", "Second"] I want to display each item on a separate line (without commas), like this: First Second I attempted splitting the array using: let data.split("\n") However, the output was: ...

javascriptarrayssplit

What is the best way to pass a function as a prop from a parent component to a child component and access it?

I am currently attempting to pass a function as a prop to a child component, DetailViewOfEntity, that is defined in the parent component, App.js. However, when I click on the button, I encounter an error stating that this.setState and obj.detailview are no ...

javascriptreactjs

The protected routes within a React JS application consistently result in an undefined value

In my ProtectedRoute component for my react application, I am facing an issue with user authentication. I am using react-router-dom v6 to access the token from localStorage, but no matter what, the user variable always returns undefined. import { Outlet, N ...

javascriptreactjsreact-router-dom

Troubleshooting problem with sorting in Angular 4 material header

Using Angular 4 material for a table has presented me with two issues: 1. When sorting a table, it displays the description of the sorting order in the header. I would like to remove this. https://i.sstatic.net/5bHFO.png It displays "Sorted by ascending o ...

javascripthtmlangulartypescriptangular-cdk

If the variable is empty, use jQuery ajax to send a request with different data

Below is the code I have written: $(document).ready(function() { cookieanimalid =($.cookie("cookieanimal")); $.ajax({ type: 'POST', url: "/myurl/", data: {cookieanimalid}, success: function ( ...

javascriptjqueryajax

Always Seek Permission for Geolocation in Cordova

Is there a way in PhoneGap to update the Geolocation plugin's permissions from "while in use" to "always" without manually editing the .plist file? I noticed that changing the NSLocationAlwaysUsageDescription key in the project's config.xml sets ...

javascriptioscordovapermissionsgeolocation

"Looking to display an image object retrieved from AWS S3 using a signed URL in Vue.js? Here's how you

<div v-for="(data, key) in imgURL" :key="key"> <img :src= "getLink(data)" /> </div> imgURL here is an array that contains file names. methods: { async getLink(url){ let response = await PostsService.downloadURL({ i ...

javascriptamazon-s3vue.jsvuejs2base64

Modify background color when a column is clicked in a dynamically filled table

I'm in the process of dynamically generating an HTML table as shown below: for (var i = 0; i < rowsToAdd; i++) { var tr = table.insertRow(-1); var colsToAddLength = findColsToAddLength(); for (var j = 0; j < colsToAddLength; j++) { ...

javascripthtml

SyntaxError: The input on line one ended unexpectedly and was not caught

This issue is commonly associated with messy close parentheses, however, the error is occurring on line 1 of the file! Below is the javascript code from (filename: calculate.js) var colors = new Array(); colors["SILVER"] = -2; ... Although there is m ...

javascripthtmlsyntaxsyntax-error

jQuery AJAX requests operate in a linear sequence and do not execute concurrently

I need assistance with setting up a progress bar to show the progress of a lengthy task of importing a large CSV file into a database. The process starts with an initial jQuery.ajax call and a timeout is set to retrieve the progress in percentage from the ...

javascriptjqueryajax

Establishing references to the following and previous pages

I am currently experiencing an issue with rendering images in a div that have anchor tags inside. When a user clicks on an image, I need to open an overlay screen to display PDF files using the TouchPdf plugin. What I want to achieve is to have arrow butto ...

javascriptjqueryhtmlhref

jquery Error: Unable to process input text due to invalid or unexpected character - Apostrophe found

I'm currently facing an issue with an input field that I am using to search a wide range of articles. To elaborate further, the problem arises when I enter text containing an apostrophe, resulting in the following error: Uncaught SyntaxError: Invalid ...

javascriptphpjquerycakephp

When I try to alter HTML using JS, I encounter an undefined error related to AngularJS

Using this specific function: function adjustContent(elemento){ if (document.getElementById(elemento).innerHTML.indexOf('&#10004;')>0){ document.getElementById(elemento).innerHTML=document.getElementById(eleme ...

javascripthtmlangularjs