change date formatting using java script from imported csv file

Question

I have imported CSV file to google-sheet. I have date there which comes up as 11th of August 2019 however I want it to come up as 11/08/2019. The content of csv file is converted into array and displayed. I am not certain about the approach I can take. I don't want to edit the file. Is there way of doing it without having to edit the file.

I have tried getting the range from the sheet and formatting that way but it doesn't work.


  cells.setNumberFormat("dd-mm-yyyy");

Benedikt Böhm · Accepted Answer · 2019-07-26 14:16:24Z

1

Using the momentJs library you could just do it as

moment(cells, "Do of MMMM YYYY").format('DD/MM/YYYY')

answered Jul 26, 2019 at 14:16

Benedikt Böhm

3513 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Benedikt Böhm Over a year ago

vanilla js version:

const monthMap = { Januar: "01", Februar: "02", August: "08", Dezember: "12"};    parseInt(cells) + "/" + (monthMap[cells.split(" ")[2]] + "") + "/" + cells.split(" ")[3]

Collectives™ on Stack Overflow

change date formatting using java script from imported csv file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related