Convert string date format

[leoborlot]

Hi guys, thanks for every help then you give to me.

Now i need to solve this. I have a value sting date, I need to reformat it.
the orignal --> new format.
06/11/2020 --> 2020-11-06

How may I do it?

[fellinga]

You can do something like this:

function padZero(i) {
    return i < 10 ? "0"+i : i;
}

const dateString = "06/11/2020";
const parts = dateString.split("/");
const date = new Date(Number(parts[2]), Number(parts[1]) - 1, Number(parts[0]));

const newDateString = date.getFullYear()+'-' + (padZero(date.getMonth()+1)) + '-'+padZero(date.getDate());

[leoborlot]

lets me try this!

[edje11]

Now is the question or the input date is US or rest of the world notation.
Eq is 6 the month or 11 the month

[leoborlot]

@fellinga

function padZero(i) {
    return i < 10 ? "0"+i : i;
}

const dateString = "06/11/2020";
const parts = dateString.split("/");
const date = new Date(Number(parts[2]), Number(parts[1]) - 1, Number(parts[0]));

const newDateString = date.getFullYear()+'-' + (padZero(date.getMonth()+1)) + '-'+padZero(date.getDate());

The "official" date is DD/MM/YYYY

[Colin]

Alternatively this might do it for you, assuming it is coming in in msg.payload then
msg.payload = msg.payload.split("/").reverse().join("-")

[leoborlot]

@Colin

msg.payload = msg.payload.split("/").reverse().join("-")

Ouuuwwww, very simple!!!
It works, thanks a lot.