# Get time and date closest to current time
**URL:** https://discourse.nodered.org/t/get-time-and-date-closest-to-current-time/76545
**Category:** General
**Created:** [14 March 2023 09:06 UTC](https://discourse.nodered.org/t/get-time-and-date-closest-to-current-time/76545 "2023-03-14T09:06:35Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Belgium1](https://discourse.nodered.org/u/Belgium1)
#### Post date: [14 March 2023 09:06 UTC](https://discourse.nodered.org/t/get-time-and-date-closest-to-current-time/76545/1 "2023-03-14T09:06:35Z")
I am using Node-red to make a program for home automation. I take energy prices from the norpool api+ and format these values to just get the timestamp and also the prices per hour.
I get these values for every hour of the day. Is it possible to just get the price of the hour we are closest to. For example when it is 14/3/2023 10:0:0 to just get the price 0.1544. I want to show this value on the dashboard and also I want to make an automatisation that send values to some devices according to the current energy prices.
The code to get these values is:
[flows.json](https://discourse.nodered.org/uploads/short-url/u7DWuIPpm14X61gTE1lh6ARLQPQ.json) (1.2 KB)
```auto
{"today":[{"Tijd":"14/3/2023 00:00:00","Prijs":0.01914},{"Tijd":"14/3/2023 01:00:00","Prijs":0.00902},{"Tijd":"14/3/2023 02:00:00","Prijs":0.00818},{"Tijd":"14/3/2023 03:00:00","Prijs":0.00426},{"Tijd":"14/3/2023 04:00:00","Prijs":0.00774},{"Tijd":"14/3/2023 05:00:00","Prijs":0.02138},{"Tijd":"14/3/2023 06:00:00","Prijs":0.09126000000000001},{"Tijd":"14/3/2023 07:00:00","Prijs":0.18872},{"Tijd":"14/3/2023 08:00:00","Prijs":0.20022},{"Tijd":"14/3/2023 09:00:00","Prijs":0.18762},{"Tijd":"14/3/2023 10:00:00","Prijs":0.1544},{"Tijd":"14/3/2023 11:00:00","Prijs":0.12192},{"Tijd":"14/3/2023 12:00:00","Prijs":0.09337999999999999},{"Tijd":"14/3/2023 13:00:00","Prijs":0.11236},{"Tijd":"14/3/2023 14:00:00","Prijs":0.13136},{"Tijd":"14/3/2023 15:00:00","Prijs":0.1218},{"Tijd":"14/3/2023 16:00:00","Prijs":0.16091999999999998},{"Tijd":"14/3/2023 17:00:00","Prijs":0.268},{"Tijd":"14/3/2023 18:00:00","Prijs":0.314},{"Tijd":"14/3/2023 19:00:00","Prijs":0.4096},{"Tijd":"14/3/2023 20:00:00","Prijs":0.3207},{"Tijd":"14/3/2023 21:00:00","Prijs":0.35926},{"Tijd":"14/3/2023 22:00:00","Prijs":0.31760000000000005},{"Tijd":"14/3/2023 23:00:00","Prijs":0.3092}]}
```
Thanks in advance
---
### Author:  [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [14 March 2023 09:38 UTC](https://discourse.nodered.org/t/get-time-and-date-closest-to-current-time/76545/2 "2023-03-14T09:38:15Z")
You can use a change node with JSONata and $moment() to return the correct hour.
e.g.
```auto
[{"id":"143738ee202674db","type":"inject","z":"e109375995a10df2","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"today\":[{\"Tijd\":\"14/3/2023 00:00:00\",\"Prijs\":0.01914},{\"Tijd\":\"14/3/2023 01:00:00\",\"Prijs\":0.00902},{\"Tijd\":\"14/3/2023 02:00:00\",\"Prijs\":0.00818},{\"Tijd\":\"14/3/2023 03:00:00\",\"Prijs\":0.00426},{\"Tijd\":\"14/3/2023 04:00:00\",\"Prijs\":0.00774},{\"Tijd\":\"14/3/2023 05:00:00\",\"Prijs\":0.02138},{\"Tijd\":\"14/3/2023 06:00:00\",\"Prijs\":0.09126000000000001},{\"Tijd\":\"14/3/2023 07:00:00\",\"Prijs\":0.18872},{\"Tijd\":\"14/3/2023 08:00:00\",\"Prijs\":0.20022},{\"Tijd\":\"14/3/2023 09:00:00\",\"Prijs\":0.18762},{\"Tijd\":\"14/3/2023 10:00:00\",\"Prijs\":0.1544},{\"Tijd\":\"14/3/2023 11:00:00\",\"Prijs\":0.12192},{\"Tijd\":\"14/3/2023 12:00:00\",\"Prijs\":0.09337999999999999},{\"Tijd\":\"14/3/2023 13:00:00\",\"Prijs\":0.11236},{\"Tijd\":\"14/3/2023 14:00:00\",\"Prijs\":0.13136},{\"Tijd\":\"14/3/2023 15:00:00\",\"Prijs\":0.1218},{\"Tijd\":\"14/3/2023 16:00:00\",\"Prijs\":0.16091999999999998},{\"Tijd\":\"14/3/2023 17:00:00\",\"Prijs\":0.268},{\"Tijd\":\"14/3/2023 18:00:00\",\"Prijs\":0.314},{\"Tijd\":\"14/3/2023 19:00:00\",\"Prijs\":0.4096},{\"Tijd\":\"14/3/2023 20:00:00\",\"Prijs\":0.3207},{\"Tijd\":\"14/3/2023 21:00:00\",\"Prijs\":0.35926},{\"Tijd\":\"14/3/2023 22:00:00\",\"Prijs\":0.31760000000000005},{\"Tijd\":\"14/3/2023 23:00:00\",\"Prijs\":0.3092}]}","payloadType":"json","x":390,"y":140,"wires":[["72511b991e8b6e44"]]},{"id":"72511b991e8b6e44","type":"change","z":"e109375995a10df2","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"(\t $hour := $moment().format(\"HH\");\t $$.payload.today[\t $moment($.Tijd,\"DD/MM/YYYY HH:mm:ss\").format(\"HH\") = $hour\t]\t)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":600,"y":140,"wires":[["1add140e06f21e2f"]]},{"id":"1add140e06f21e2f","type":"debug","z":"e109375995a10df2","name":"debug 29","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":840,"y":180,"wires":[]}]
```
exprssion
```auto
(
$hour := $moment().format("HH");
$$.payload.today[
$moment($.Tijd,"DD/MM/YYYY HH:mm:ss").format("HH") = $hour
]
)
```
---
### Author:  [@Belgium1](https://discourse.nodered.org/u/Belgium1)
#### Post date: [14 March 2023 10:00 UTC](https://discourse.nodered.org/t/get-time-and-date-closest-to-current-time/76545/3 "2023-03-14T10:00:51Z")
Thank you for the quick reply. This worked perfect.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [28 March 2023 10:01 UTC](https://discourse.nodered.org/t/get-time-and-date-closest-to-current-time/76545/4 "2023-03-28T10:01:41Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.