# Payload: "error: date/time field value out of range: "1651045559726 07:00:00""

**URL:** <https://discourse.nodered.org/t/payload-error-date-time-field-value-out-of-range-1651045559726-0700/61852>\
**Category:** Dashboard\
**Tags:** database, function-node\
**Created:** [27 April 2022 08:13 UTC](https://discourse.nodered.org/t/payload-error-date-time-field-value-out-of-range-1651045559726-0700/61852 "2022-04-27T08:13:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![learnobyte](https://avatars.discourse-cdn.com/v4/letter/l/d6d6ee/32.png) [@learnobyte](https://discourse.nodered.org/u/learnobyte)\
**Post date:** [27 April 2022 08:13 UTC](https://discourse.nodered.org/t/payload-error-date-time-field-value-out-of-range-1651045559726-0700/61852/1 "2022-04-27T08:13:14Z")

</div>

Hi, i got date/time field value out of range error,. using PostgreSQL,getting date/time value for today and tomorrow. it is working fine, some times the date/time format node gives timestamp value, not in YYYY-MM-DD,

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

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [27 April 2022 17:09 UTC](https://discourse.nodered.org/t/payload-error-date-time-field-value-out-of-range-1651045559726-0700/61852/2 "2022-04-27T17:09:53Z")

</div>

What is generating the input value? Not clear from the image what generates the output in the red box.

---

<div class="post-metadata">

**Author:** ![learnobyte](https://avatars.discourse-cdn.com/v4/letter/l/d6d6ee/32.png) [@learnobyte](https://discourse.nodered.org/u/learnobyte)\
**Post date:** [28 April 2022 03:26 UTC](https://discourse.nodered.org/t/payload-error-date-time-field-value-out-of-range-1651045559726-0700/61852/3 "2022-04-28T03:26:51Z")

</div>

I have an issue in Date/Time format node. I am collecting the current date and time, then formatting to YYYY-MM-DD as output from "today" (date/time formate node). I am getting in payload - YYYY-MM-DD format, if u see in the image "tgl1", after some time, say less than a minute, I m getting payload without formatting, like timestamp, marked in box, After that again getting YYYY-MM-DD format,

When the error comes, the payload is the current timestamp, if no error payload is the current date. It comes continuously, not random

This is the node m using:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/5/054327233eefc4922cdb605dd2c73f518003cdbd.png)

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

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [28 April 2022 12:10 UTC](https://discourse.nodered.org/t/payload-error-date-time-field-value-out-of-range-1651045559726-0700/61852/4 "2022-04-28T12:10:36Z")

</div>

Not sure what is going on but the whole flow seems a little over-engineered and unnecessary. The inject node's default payload is a timestamp which is the current date and time. If you only need todays date, set the inject to run every 24hrs by setting it to a specific time.

---

<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:** [28 May 2022 12:11 UTC](https://discourse.nodered.org/t/payload-error-date-time-field-value-out-of-range-1651045559726-0700/61852/5 "2022-05-28T12:11:00Z")

</div>

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