# Set Time in a DATE PICKER

**URL:** <https://discourse.nodered.org/t/set-time-in-a-date-picker/59144>\
**Category:** General\
**Tags:** node-red-dashboard\
**Created:** [28 February 2022 22:02 UTC](https://discourse.nodered.org/t/set-time-in-a-date-picker/59144 "2022-02-28T22:02:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DemalCal96](https://avatars.discourse-cdn.com/v4/letter/d/f4b2a3/32.png) [@DemalCal96](https://discourse.nodered.org/u/DemalCal96)\
**Post date:** [28 February 2022 22:02 UTC](https://discourse.nodered.org/t/set-time-in-a-date-picker/59144/1 "2022-02-28T22:02:27Z")

</div>

Hello to all. In my dashboard I am using two data pickers to select a date range that is used to extract data from a database. The problem I have is that I need the first date to be set to time 00:00:00 (at the start of the day) and the end time to be set to 23:59:59 (at the end of the day), to make sure that all the data between those dates is collected. I noticed this problem because selecting both the same date (for example February 28th in both) does not show me any data. I look forward to your help and thank you in advance.

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [28 February 2022 22:24 UTC](https://discourse.nodered.org/t/set-time-in-a-date-picker/59144/2 "2022-02-28T22:24:01Z")

</div>

The date picker gives the timestamp at 00:00 on that day so you could add 86 399 000 microseconds to your end date to get 23:59:59.

---

<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:** [31 March 2022 20:27 UTC](https://discourse.nodered.org/t/set-time-in-a-date-picker/59144/3 "2022-03-31T20:27:18Z")

</div>

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