SUBSTR in Change Node - HELP Needed

[championc]

Hi all

I have a Date and Time string - a runrise date and time - which I am simply looking to extract the time. from. But I keep getting an "undefined" result in the debug messages

Here is a string sample - "2022-11-23T08:04:01+0000"

I have a change node to give me msg.payload from msg.payload.sunriseTimeLocal.substr(11,5), so it doesn't like the substr(11,5)

Where am I going wrong please ?

[TotallyInformation]

Change nodes are static unless you use JSONata, you can't use JavaScript.

[championc]

Ah ha,

As it turns out, it IS part of JSON Data. The actual element (if that is the correct word !!) is
payload.sunriseTimeLocal[0]

It contains "2022-11-23T08:04:01+0000"

So how would I get 08:04 out of this

[bakman2]

You can use the change node with a JSONata expression:

payload.sunriseTimeLocal.$moment($).utc().format("HH:mm")

If you only want the first one in the array

$moment(payload.sunriseTimeLocal[0]).utc().format("HH:mm")

[championc]

Thanks for that. I must be missing a plugin or some node. I have the Moment plugin installed. I only need the first one in the array

[bakman2]

You don't need the moment plugin, it is part of the jsonata package within node-red.

How did you configure the change node ? Did you set it to an jsonata expression ?

[championc]

Ah - I missed the jsonata expression bit