# Reading data from MSSQL for a date range using DatePicker

**URL:** <https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928>\
**Category:** General\
**Created:** [9 December 2022 15:39 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928 "2022-12-09T15:39:37Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![maskmanwithsword](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@maskmanwithsword](https://discourse.nodered.org/u/maskmanwithsword)\
**Post date:** [9 December 2022 15:39 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928/1 "2022-12-09T15:39:37Z")

</div>

Hi, Im having problem when reading data from MSSQL. I can't get the SQL statement right and get this error always. I did try to change the format type to the same as MSSQL, but it didn't work.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/a/1a78615dbec3e4f08af95f15627ae677311c8ba3.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/6/a68e5d82b4c6086b5d029a0b59177a0bdbf4543c.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/1/e19df76ac681485dd35698ab90ceb9a83897df35.png)

this is my flow:  
[flows.json](https://discourse.nodered.org/uploads/short-url/czxVklhIhTApM8pReISpir7YX1P.json) (7.1 KB)

---

<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:** [9 December 2022 15:48 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928/2 "2022-12-09T15:48:29Z")

</div>

You have created an ISO8601 timestamp format which is incorrect for MSSQL. Correct format for MSSQL is `'YYYY-MM-DD HH:MM:SS'`, e.g. `'2022-12-09 12:34:56'`.

---

<div class="post-metadata">

**Author:** ![maskmanwithsword](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@maskmanwithsword](https://discourse.nodered.org/u/maskmanwithsword)\
**Post date:** [9 December 2022 15:57 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928/3 "2022-12-09T15:57:30Z")

</div>

I did try, but still get the same error

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/2/123ef206b358492e73681845b130a3cc24ab0135.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:** [9 December 2022 16:19 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928/4 "2022-12-09T16:19:42Z")

</div>

No you haven't - check that date string again, it is not `'YYYY-MM-DD HH:MM:SS'`, it is `'YYYY-MM-D H:M:S'`

---

<div class="post-metadata">

**Author:** ![maskmanwithsword](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@maskmanwithsword](https://discourse.nodered.org/u/maskmanwithsword)\
**Post date:** [9 December 2022 16:30 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928/5 "2022-12-09T16:30:27Z")

</div>

I try again, and this is the result

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

---

<div class="post-metadata">

**Author:** ![maskmanwithsword](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@maskmanwithsword](https://discourse.nodered.org/u/maskmanwithsword)\
**Post date:** [9 December 2022 17:31 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928/6 "2022-12-09T17:31:42Z")

</div>

I'm wrong in using flow variable, it works now with your suggest, thank you!

---

<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:** [23 December 2022 17:32 UTC](https://discourse.nodered.org/t/reading-data-from-mssql-for-a-date-range-using-datepicker/71928/7 "2022-12-23T17:32:02Z")

</div>

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