Mustache date format

General
1

Hello together,
I have the following issue.
I have stored several values in a database with a time stamp.
The time stamp has the following format
Timestamp: "2019-08-26T00:00:00.000Z"
With the following mustache, I would now like to access the value
{{payload.0.payload.Timestamp}}
I get returned within the html
Mon Aug 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
But I use the values in a diagram, I need the following format
YYYY-MM-DD
I have already tried a lot but unfortunately without success
{{payload.0.payload.Timestamp | date:"yyyy-MM-dd"}}
for example doesnt´show anything.
Hope someone can help me

Thanks

1 Like
2

Install the moment node, that can do the conversion easily.

3

I presume this is actually about the dashboard
the form {{payload.0.payload.Timestamp | date:"yyyy-MM-dd"}} is a mix of two styles
either you can use {{value | date:"yyyy-MM-dd"}} which is using an angular filter (not mustache) and feed in the date on the msg.payload - or you can use {{payload.0.payload.Timestamp}} and format that up yourself in advance. (possibly using the moment node as mentioned)