# Compiling Date and Time to a readable value

**URL:** https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803
**Category:** General
**Created:** [7 June 2021 10:03 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803 "2021-06-07T10:03:58Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![swanside](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/swanside/32/28781_2.png) [@swanside](https://discourse.nodered.org/u/swanside)
#### Post date: [7 June 2021 10:03 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/1 "2021-06-07T10:03:58Z")

</div>

Hello again  
I can get the minutes, Seconds Hours, day, month and year from my device, but I cant figure out how to make it readable. Any pointers please? Thanks

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/8/9841b161e0a0eb11410eba0f14788e398363d3fe.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/f/0fa6bf962028c1789438de2ebee9186544b36ba1.png)

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [7 June 2021 10:12 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/2 "2021-06-07T10:12:48Z")

</div>

- Change the buffer parser to output a single value (disable fan out) & set the output type to `key/value`
- Connect it to a function node containing...

```auto
const d = new Date(msg.payload.Year, msg.payload.Month-1, msg.payload.Day, msg.payload.Hour, msg.payload.Minutes, msg.payload.Seconds);
msg.payload = d
return msg;

```

See: [Date - JavaScript | MDN](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date#examples)

---

<div class="post-metadata">

### Author: ![swanside](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/swanside/32/28781_2.png) [@swanside](https://discourse.nodered.org/u/swanside)
#### Post date: [7 June 2021 11:52 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/3 "2021-06-07T11:52:55Z")

</div>

Cheers Steve.  
Did this in the end, gives me just what I need so I dont have to visit the site. Cheers

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/3/d38cb6c08092d2ed5111a44140d64a7e107b9865.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/e/4e31a62eb0c9828685df4d16d5e08a081728eac7.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/6/662e2cf85cec97e4088963c0933ff5c04669405d.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/c/4c80bad99419262d6ab7544044912910da9bd38d.png)

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [7 June 2021 12:06 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/4 "2021-06-07T12:06:33Z")

</div>

You do realise that that isnt actually using the time from your modbus data right?

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/7/07ac438c36d864380c5cb6d404258819d2bf015e.png)

this is not how you use a typedInput...  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/a/daec070e88d0c99951b4f8ec61debf6330e7ce96.png)

---

<div class="post-metadata">

### Author: ![swanside](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/swanside/32/28781_2.png) [@swanside](https://discourse.nodered.org/u/swanside)
#### Post date: [7 June 2021 12:18 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/5 "2021-06-07T12:18:20Z")

</div>

Yeh, I just realized that now 🙂

---

<div class="post-metadata">

### Author: ![swanside](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/swanside/32/28781_2.png) [@swanside](https://discourse.nodered.org/u/swanside)
#### Post date: [7 June 2021 12:22 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/6 "2021-06-07T12:22:48Z")

</div>

So in the example you gave me, `const d = new Date(msg.payload.Year, msg.payload.Month-1, msg.payload.Day, msg.payload.Hour, msg.payload.Minutes, msg.payload.Seconds); msg.payload = d return msg;`

Do I need to change the payloads to suite my output.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/8/c81882814647ae99476efed447eeb51636e15aa2.png)

So I would have msg.payload.minute, msg.payload.second, and so on?

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [7 June 2021 12:24 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/7 "2021-06-07T12:24:02Z")

</div>

> [@swanside](#):
>
> So I would have msg.payload.minute, msg.payload.second, and so on?

Well, since you already had that

> [@swanside](#):
>
> ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/f/0fa6bf962028c1789438de2ebee9186544b36ba1.png)
> 
> image970×794 32 KB

I wrote a solution to suite...

> [@Steve-Mcl](#):
>
> - Change the buffer parser to output a single value (disable fan out) & set the output type to `key/value`
> - Connect it to a function node containing...
> 
> ```auto
> const d = new Date(msg.payload.Year, msg.payload.Month-1, msg.payload.Day, msg.payload.Hour, msg.payload.Minutes, msg.payload.Seconds);
> msg.payload = d
> return msg;
> 
> ```

---

<div class="post-metadata">

### Author: ![swanside](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/swanside/32/28781_2.png) [@swanside](https://discourse.nodered.org/u/swanside)
#### Post date: [7 June 2021 13:07 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/8 "2021-06-07T13:07:13Z")

</div>

> [@Steve-Mcl](#):
>
> ```auto
> const d = new Date(msg.payload.Year, msg.payload.Month-1, msg.payload.Day, msg.payload.Hour, msg.payload.Minutes, msg.payload.Seconds);
> msg.payload = d
> return msg;
> 
> ```

So Sorry.  
I get you now. I now have changed it and now it makes sense to me.  
Thank you so much for your help.  
I guess I need to visit site

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/8/98b2c0021aef4889a54b86960eafdc33fdddcbd5.png)

---

<div class="post-metadata">

### Author: ![swanside](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/swanside/32/28781_2.png) [@swanside](https://discourse.nodered.org/u/swanside)
#### Post date: [7 June 2021 13:46 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/9 "2021-06-07T13:46:59Z")

</div>

Now its correct

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/f/bf9409a6980a244024d71e02308164e93bb3c1d5.png)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [6 August 2021 13:47 UTC](https://discourse.nodered.org/t/compiling-date-and-time-to-a-readable-value/46803/10 "2021-08-06T13:47:44Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
